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

Bug with time zone. Bug with forum statistics query [message #14498]

Sun, 16 November 2003 10:09

skaiser

Messages: 5
Registered: November 2003

Karma: 0

Junior Member

Using 2.6.0 RC5

Bug with time zone
In Administrator center I set up time zone "Russia|Kaliningrad...",
but on forum pages still showing wrong time (-7 hours)

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

When renaming DB to 'somename' - query executing OK.

[Updated on: Sun, 16 November 2003 10:10]

Report message to a moderator

Re: Bug with time zone. Bug with forum statistics query [message #14509 is a reply to message #14498]

Sun, 16 November 2003 18:37

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It is likely your server does not support the timezone you've selected. You may need to try other timezones or ask your admin about the timezones that the server supports.

As a rule of thumb you should never name your databases using numeric characters. Infact in MySQL you cannot even do that, if you try to do "CREATE DATABASE 2003" you'll get a MySQL error.

FUDforum Core Developer

Report message to a moderator

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: 0

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