FUDforum: Bug Reports » forum stats fail

Home » FUDforum Development » Bug Reports » forum stats fail

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

forum stats fail [message #6181]

Sat, 05 October 2002 00:32

Olliver

Messages: 443
Registered: March 2002

Karma: 0

Senior Member

Hi,
I've just noticed an interesting bug here Smile

. On my test system I named the database fud-forum, however it seems that the forum stats don't like it very much. when I click admstats.php in the control panel it spills out the following:

Quote:

(rid=1&S=70a7fd5ddd3a076ce8794664c7b9946d) 1064: You have an error in your SQL syntax near '-forum' at line 1
Query: SHOW TABLE STATUS FROM fud-forum
Server Version: 3.23.52
[Referring Page] http: // hit0kiri.intern:65535/forum/adm/admglobal.php?rid=...

As one can see it definitely seems to be an issue with the database's name.
System is:

Quote:

PHP built On: Linux hit0kiri.intern 2.4.18-10 #1 Wed Aug 7 11:41:24 EDT 2002 i586 i586 i386 GNU/Linux
MySQL Version: 3.23.52
PHP Version: 4.2.4-dev
Web Server: Apache/1.3.27 (Unix) PHP/4.2.4-dev mod_perl/1.26
WebServer to PHP interface: apache
Forum Version: 2.3.2
Relavent PHP Settings:
Safe Mode: OFF
Display Errors: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: ON
Output Buffering: ON
Disabled Functions: none
PSpell Support: Yes

It's a fresh installation so it's unlikely an issue with corrupted tables.
bye
Ken

Report message to a moderator

Re: forum stats fail [message #6189 is a reply to message #6181]

Sat, 05 October 2002 13:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

As you can well see the 'SHOW TABLE STATUS FROM fud-forum' query perfectly valid. Replacing the table name with anything works just fine, I suspect the problem is that MySQL does not like table names with a '-' in their names.
On a simular note, if you do: 'SHOW TABLE STATUS FROM fud\-forum' does it work?

FUDforum Core Developer

Report message to a moderator

Re: forum stats fail [message #6199 is a reply to message #6189]

Sat, 05 October 2002 16:24

Olliver

Messages: 443
Registered: March 2002

Karma: 0

Senior Member

Hi Protoss,
I played around with some queries. Indeed, u were right, mySQL doesn't want me to use dashes Smile

. If it's like this then maybe the installation routine could spit out a warning whenever someone tries to use a database with such a name. Strange indeed, as normally I use underscores for the name so I haven't noticed it earlier. BTW, "fud\-forum" doesn't work either.
Thnx for taking the time Smile

bye Ken

Report message to a moderator

Re: forum stats fail [message #6202 is a reply to message #6199]

Sat, 05 October 2002 16:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Hmm, to be honest I am not sure how installion had ever worked, considering it did a fair deal of inserts and create table queries.
I am not sure that it's FUDforum's job to check for these things. Ultimately there is only so much 'hand-holding' we can do, so I am yet undecided about adding a check. Feel free to try to sway me either way Smile

FUDforum Core Developer

Report message to a moderator

Re: forum stats fail [message #6205 is a reply to message #6202]

Sat, 05 October 2002 17:11

Olliver

Messages: 443
Registered: March 2002

Karma: 0

Senior Member

prottoss wrote on Sat, 05 October 2002 18:59

Hmm, to be honest I am not sure how installion had ever worked, considering it did a fair deal of inserts and create table queries.

True, this is the part of the issue which I don't understand at all. How comes that I succeeded in installing the forum without any problems? Would be interesting to know Smile

Quote:

I am not sure that it's FUDforum's job to check for these things. Ultimately there is only so much 'hand-holding' we can do, so I am yet undecided about adding a check.

Well, it was only a suggestion to save u from more "my admstats.php is broken, pls fix it" postings Wink

. Normally hosting companies use underscored names for their costumers so chances are low it would ever happen.
bye Ken

Report message to a moderator

Previous Topic:	Wrong Signature a Preview
Next Topic:	installation and upgrade script fail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 12:55:55 GMT 2024

Total time taken to generate the page: 0.04495 seconds