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
|
|
|
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
|
|
|
|
|
Re: Bug with forum statistics query [message #16497 is a reply to message #16495] |
Tue, 03 February 2004 00:16 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You're fix is a correct one, and I've applied to the CVS. I'd still recommend (for all other users) to not name database using numeric characters.
FUDforum Core Developer
|
|
|