PDA

View Full Version : Invalid SQL Error


Ramses
09-04-2005, 08:44 PM
If I want to change the name of a directory get this error:
Invalid SQL:
UPDATE vb3_links_categories SET title = 'Deutschland', '', parent = '0', haslinks = '0', displayorder = '4', private = '0', options = '6111', newlinkemail = '', newpostemail = '' WHERE catid = '4';

MySQL Error : You have an error in your SQL syntax near ''', parent = '0', haslinks = '0', displayorder = '4', private = '0', options = '' at line 1 Error Number : 1064

Brian
09-05-2005, 05:36 PM
Haven't heard of that one happening to anyone before... Would you mind submitting a support ticket via the Members' Area here so I can have a look?

Our Sponsors
 

Ramses
09-05-2005, 09:48 PM
I know where the mistake was, changed the vba_links_admin.php same as discribed in your posting
HTML links in description field
Currently that is not how things are set up. If you would like to change that though, open your linksadmin.php file and look for:
'" . addslashes(htmlspecialchars($title)) . "', '" . addslashes(htmlspecialchars($description)) . "'
Now I put the origninal vba_links_admin.php back and it's working fine again.