Datbase Error

[urbangamerz]

mySQL query error: SELECT p.mid, p.tid, t.nbtries, p.timesplayed, p.faceoff, p.rung FROM urbangamerz4328748923749187293192477519_tournament _players AS p LEFT JOIN urbangamerz4328748923749187293192477519_tournament s AS t ON (p.tid=t.tid) LEFT JOIN urbangamerz4328748923749187293192477519_tournament _players_statut AS s ON (p.tid=s.tid AND p.mid=s.mid) WHERE p.timesplayed<t.nbtries AND p.notified=0 AND t.demare=1 AND s.statut=0 AND p.timeplayed<1209421792

mySQL error: Incorrect table name 'urbangamerz4328748923749187293192477519_tournamen t_players_statut'
mySQL error code:
Date: Thursday 01st of May 2008 05:29:52 PM


I installed it correctly but it seems that the databases aren't being imported from the product xml any ideas on how to implent them manually?

--------------- Added 1209692513 at 1209692513 ---------------

so no help?

[MrZeropage]

3 hours 10 minutes and asking "no help?" ... :erm:


Did the XML got imported correctly ? Is the main arcade page loading ?

[urbangamerz]

nope you can view it for yourself @ http://www.urbangamerz.net/forums/arcade.php it gives the error i pasted.

AND yes i did import it correctly i have used an older version of the script before... i dont know what is wrong.

--------------- Added 1209717304 at 1209717304 ---------------

I'm going to try redoing my forums prefix maybe i put it in too long hopefully that will fix i will tell you if it did reuploading my database atm.

--------------- Added 1209722567 at 1209722567 ---------------

3 hours 10 minutes and asking "no help?" ... :erm:


Did the XML got imported correctly ? Is the main arcade page loading ?

and uh its been 8 hours x.x

[MrZeropage]

provide access to FTP and AdminCP via PM and I will check this ...

[urbangamerz]

i fixed it nvm.

BUT THANKS FOR THE HELP!! you have been wonderful

[MrZeropage]

what was the problem ?

Just to learn from this and help others in the future ...