Page 1 of 1

SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 12:04 pm
by fahad4x4
Hello everyone

Please help me in solving this problem

Code: Select all

SQL ERROR [ mysql4 ]

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 'AND t.template_id = s.template_id AND c.theme_id = s.theme_ [1064]

SQL

SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_styles s, phpbb_styles_template t, phpbb_styles_theme c, phpbb_styles_imageset i WHERE s.style_id = AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1360
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 26
CALL: user->setup()

Re: SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 12:50 pm
by zeroK
Have you just installed a new style? If so, can you access the admin panel and deactive/uninstall that new style?

Re: SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 5:22 pm
by fahad4x4
The problem that I can not access the control panel and the forum was on hold because of this problem

Is there a database to Make prosilver style Default

Re: SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 5:50 pm
by zeroK

Code: Select all

UPDATE phpbb_config SET config_value = '1' WHERE config_name = 'default_style';
UPDATE phpbb_users SET user_style = 1;
This should do it.

Re: SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 5:59 pm
by fahad4x4
hi

A thanked the problem was solved.
But now I can not enter the control panel forum where a message appears that says:
The mistake of
Need to enter the password to enter the dashboard management

Re: SQL ERROR [ mysql4 ]

Posted: Sun Oct 28, 2007 6:32 pm
by fahad4x4
Welcome

The problem was solved by the subject
http://www.phpbb.com/community/viewtopi ... 6&t=585552