FUDforum: Bug Reports » Bug with time zone. Bug with forum statistics query

Home » FUDforum Development » Bug Reports » Bug with time zone. Bug with forum statistics query

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

Re: Bug with forum statistics query [message #16490 is a reply to message #14498]

Mon, 02 February 2004 23:59

sapienz

Messages: 6
Registered: June 2003
Location: Moscow

Karma:

Junior Member

skaiser wrote on Sun, 16 November 2003 05:09

Bug with forum statistics query:
When DB name like '2003' (digits only) - Query failed when trying to see forum stats.
(admstats.php:170 ) 1064: 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 '2003 LIKE 'fud26_%'' at line 1
Query: SHOW TABLE STATUS FROM 2003 LIKE 'fud26_%'
Server Version: 4.0.16-log

Hi Ilja,

I am using 2.6.0 release and got the same error on statistics query:

 SQL-запрос : 

SHOW TABLE STATUS FROM m2857 - 1 LIKE 'fud238_%'

Ответ MySQL:

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 '- 1 LIKE  'fud238_%'' at line 1

I am sure, there are troubles with database name: "m2857-1".
To fix this bug, you should write:

SHOW TABLE STATUS FROM `DatabaseName` LIKE 'fud238_%'
but not
SHOW TABLE STATUS FROM DatabaseName LIKE 'fud238_%'

Could you change your code or tell me where can I do it?

[Updated on: Tue, 03 February 2004 00:08]

Report message to a moderator

[Message index]

		Bug with time zone. Bug with forum statistics query By: skaiser on Sun, 16 November 2003 10:09
		Re: Bug with time zone. Bug with forum statistics query By: Ilia on Sun, 16 November 2003 18:37
		Re: Bug with forum statistics query By: sapienz on Mon, 02 February 2004 23:59
		Re: Bug with forum statistics query By: Ilia on Tue, 03 February 2004 00:05
		Re: Bug with forum statistics query By: sapienz on Tue, 03 February 2004 00:11
		Re: Bug with forum statistics query By: Ilia on Tue, 03 February 2004 00:16

Previous Topic:	pathinfo issues
Next Topic:	Newsgroups create duplicates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 17:42:58 GMT 2024

Total time taken to generate the page: 0.03929 seconds