PDA

View Full Version : database error

agiacosa
10-14-2005, 12:48 PM
I had your Auto-Linker in 3.0 then upgraded to 3.5 with the Lite. It didn't work as I got a database error. I purchased Auto Linker Pro and when I try to update styles, I get the same database error. It is:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM geek_autolink WHERE catid = 1;

MySQL Error : Unknown column 'catid' in 'where clause'
Error Number : 1054
Date : Friday, October 14th 2005 @ 07:50:06 AM
Script : http://www.aquaticplantcentral.com/forumapc/admincp/GAL_admin.php
Referrer : http://www.aquaticplantcentral.com/forumapc/admincp/GAL_admin.php?do=styles
IP Address : 65.2.14.238
Username : Art_Giacosa
Classname : vb_database

Little help please.
The Geek
10-14-2005, 01:11 PM
SOunds like you had a much older version of GAL installed when you upgraded to the lite version. CatID was added yonks ago.

hmmm... DO you have many links that need porting?
agiacosa
10-14-2005, 02:55 PM
Yes, but I am willing to manually add them if that makes things easier.
The Geek
10-14-2005, 03:05 PM
I think you may need to uninstall and then re-install. Thats why Im asking. You must be running a pretty pld version and I am therefore just not sure what steps need to be taken without looking at the DB scheme. If you provide me with that, I may be able to help.
agiacosa
10-14-2005, 03:17 PM
I am running an old version for 3.0.5 but it doesn't work anymore once I upgraded to vB 3.5.

How do I uninstall?
I can provide you with a db scheme downloaded from phpmyadmin if you still need it.
The Geek
10-14-2005, 03:30 PM
why dont you do that as your first step. It will make things a bit easier
agiacosa
10-14-2005, 04:28 PM
You've got PM.

Thanks.
agiacosa
10-15-2005, 06:19 PM
Geek, any news? Sorry to pester but losing affiliate revenue without it.