Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Another weird SQL error...

Quote Reply
Another weird SQL error...
Mmm.. the following code;

$DB->table('SpiderURLS')->update( { AlreadyChecked => "1" }, { URL => "$_" } ) or die $GT::SQL::error;

.. gives me the following error;

Failed to execute query: 'UPDATE lsql_SpiderURLS SET WHERE URL = ?' Reason: You have an error in your SQL syntax near 'WHERE URL = 'http://www.skydivelinks.com/index.php?PHPSESSID=4e823509fd4b27a74e3' at ...

Note the AlreadyChecked = 1 bit seems to be missing :/

Any ideas?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Another weird SQL error... In reply to
Ah, found the problem. I manually added the 'Category' field in MySQLMan,so the .def file didn't have the value in it. I did a re-sync on that table,and that has sorted it :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!