FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Forum Statistics with DB name error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Forum Statistics with DB name error [message #11796] Thu, 17 July 2003 17:34 Go to next message
gbjbaanb is currently offline  gbjbaanb   United Kingdom
Messages: 41
Registered: February 2003
Location: UK
Karma: 0
Member
FYI: I tried to view statistics on my forum, and received the following error:
Quote:

(admstats.php) 1064: You have an error in your SQL syntax near '-talon_org_-_forum LIKE 'fud23_%'' at line 1
Query: SHOW TABLE STATUS FROM project-talon_org_-_forum LIKE 'fud23_%'
Server Version: 3.23.56
[Referring Page] http://www.project-talon.org/forum/adm/admstats.php?rid=2&S=ea89e28feba 096b78aa06e677aa7a9ee


looks like it didn't like 'project-' at the beginning of the database name. (no, I didn't choose that prefix Smile )
Re: Forum Statistics with DB name error [message #11797 is a reply to message #11796] Thu, 17 July 2003 17:42 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
It looks like the prefix is wrong, using "-" in the MySQL prefix is not a good idea, as the error indicates it appears to cause a problem for "SHOW TABLE STATUS" query. It may infact be a MySQL bug, since I presume the rest of the forum work fine with this admitedly weird table prefix. I would suggest that you report this query failure to MySQL.

FUDforum Core Developer
Re: Forum Statistics with DB name error [message #11800 is a reply to message #11797] Thu, 17 July 2003 18:03 Go to previous message
gbjbaanb is currently offline  gbjbaanb   United Kingdom
Messages: 41
Registered: February 2003
Location: UK
Karma: 0
Member
OK. Will do. Cheers.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Private msgs Online indicator fix
Next Topic: Error in apache logs
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 20:49:18 GMT 2024

Total time taken to generate the page: 0.02936 seconds