i cant add links and Database error

[servando]

(Sorry, i don't speak english).

Change server after I can not add new links from the website form, nor I, nor the users. When I send the form with the data takes too long to respond and finally said that the URL is invalid.

I as an Administrator I can add links from the Admin CP, but not from website form.

Another mistake is when I use the following tool from Admin CP: "This tool will allow you to update your counters category". I get the following error:

Database error in vBulletin XXXXX:

Invalid SQL:

UPDATE adv_links_categories SET ,
lastlinkid = '',
lastlinkdateline = '',
lastlinktitle = '',
lastlinkusername = '',
lastlinkuserid = '' WHERE catid = '1' AND haslinks = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
lastlinkid = '',
lastlinkdateline = '',
lastlinktitle = ''' at line 1
Error Number : 1064
Date : Tuesday, April 20th 2010 @ 01:24:53 AM
Script : http://www.xxxxxxxxxxxxxx
Referrer : http://www.xxxxxxxxxxxxxx
IP Address : 91.39.190.234
Username : xxxxxxx
Classname : vB_Database

I repeat that this problem occurs since I changed to a new server, before changing the server worked perfectly.

My version of vBadvanced Links Directory is v2.0.1

[Brian]

v2.0.1 is well over 3 years old now, so I would highly suggest upgrading to v3.2.0.

[servando]

Hi, Brian

I know it's an older version but I would like to solve this problem first and then upgrade the Links Directory and the forum, which is also old. Before i changed the server five days ago it worked perfectly.


Please, can you tell me what you think is the cause of this problem to find a solution now?

[Brian]

It's hard to say what the error is at this point considering the version you're running is so old. You can check the v2.0.1 bugs forum here to see if anything was posted in there. Or, once you upgrade to 3.2.0, the issue should be solved.