FUDforum: Bug Reports » Forum Statistics with DB name error

Home » FUDforum Development » Bug Reports » Forum Statistics with DB name error

Show: Today's Messages :: Polls :: Message Navigator

Forum Statistics with DB name error [message #11796]

Thu, 17 July 2003 17:34

gbjbaanb

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

)

Report message to a moderator

Re: Forum Statistics with DB name error [message #11797 is a reply to message #11796]

Thu, 17 July 2003 17:42

Ilia

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

Report message to a moderator

Re: Forum Statistics with DB name error [message #11800 is a reply to message #11797]

Thu, 17 July 2003 18:03

gbjbaanb

Messages: 41
Registered: February 2003
Location: UK

Karma: 0

Member

OK. Will do. Cheers.

Report message to a moderator

Previous Topic:	Private msgs Online indicator fix
Next Topic:	Error in apache logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:58:23 GMT 2024

Total time taken to generate the page: 0.02639 seconds