“SQL error in 2.07” – Forum Thread – Discuss

3 users online. Create an account or sign in to join them.Users

SQL error in 2.07

This is an open discussion with 1 reply, filed under General.

While setting up a fresh install (downloaded from symphony-cms.com) of 2.07, I ran into a database error caused by line 465.

The error happens when I try to enter a word with an apostrophe (foto’s).

As a fix, I replaced

elseif(Symphony::Database()->fetchRow(0, "SELECT * FROM `sym_sections` WHERE `name` = '" . $meta['name'] . "' LIMIT 1")){

with

elseif(Symphony::Database()->fetchRow(0, "SELECT * FROM `sym_sections` WHERE `name` = '" . mysql_real_escape_string($meta['name']) . "' LIMIT 1")){

(I really don’t like git, and I hope using the forum doesn’t bug anyone)

This was fixed a long time ago :)