Very odd error :/

Hi,

Not sure if anyone can help me, but has anyone come across this error before?



Really got me confused (mainly, as to why exactly its trying to even copy them =))

TIA

Andy (mod)
andy@ultranerds.com

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates

Hi,

Welp, after all that - I just managed to fix it (sods law I just posted :P)

Basically - there was a file named glinks2_Users.def.bak.def inside the /defs folder (god knows why!) - and deleting that now worked :)

Cheers

Andy (mod)
andy@ultranerds.com

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates

Damn, another error now :(

GT::SQL::error = Failed to execute query: 'SELECT glinks2_CatLinks.CategoryID,glinks2_CatLinks.LinkID FROM glinks2_CatLinks LEFT OUTER JOIN glinks2_Links ON WHERE (glinks2_Links.ID IS NULL) ': 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 'WHERE (glinks2_Links.ID IS NULL)' at line 1

This is on a Repair Tables. Could this be a MySQL problem?

This is a move from an NT server ==> Plesk

Cheers

Andy (mod)
andy@ultranerds.com

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates

Check your Links and CatLinks def files. The relation between them must be broken as it seems to be not joining the tables together properly there.

Adrian

Hi,

Thanks for the reply :)

In the end, I just re-setup the tables (via the Setup > SQL Server area), and then had to just re-add the fields (although there were quite a lot :() ... guess something got buggered during the transfer (had all kinds of problems with the M$ Server that it was last hosted on, as it kept on lowercasing the files - a roya PITA :()

Anyway, all seems to work fine now :)

Cheers

Andy (mod)
andy@ultranerds.com

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates