SQL ERROR [ mysql4 ]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
fahad4x4
Registered User
Posts: 15
Joined: Wed May 30, 2007 1:10 am

SQL ERROR [ mysql4 ]

Post 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()
User avatar
zeroK
Former Team Member
Posts: 20964
Joined: Sun Jan 20, 2002 7:36 pm
Location: Klagenfurt / Austria
Contact:

Re: SQL ERROR [ mysql4 ]

Post by zeroK »

Have you just installed a new style? If so, can you access the admin panel and deactive/uninstall that new style?
Image My weblog | gamerslog.com | No support via PM or ICQ or email - If you don't know a term or a program mentioned in a post -> Google is your friend
User avatar
fahad4x4
Registered User
Posts: 15
Joined: Wed May 30, 2007 1:10 am

Re: SQL ERROR [ mysql4 ]

Post 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
User avatar
zeroK
Former Team Member
Posts: 20964
Joined: Sun Jan 20, 2002 7:36 pm
Location: Klagenfurt / Austria
Contact:

Re: SQL ERROR [ mysql4 ]

Post 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.
Image My weblog | gamerslog.com | No support via PM or ICQ or email - If you don't know a term or a program mentioned in a post -> Google is your friend
User avatar
fahad4x4
Registered User
Posts: 15
Joined: Wed May 30, 2007 1:10 am

Re: SQL ERROR [ mysql4 ]

Post 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
User avatar
fahad4x4
Registered User
Posts: 15
Joined: Wed May 30, 2007 1:10 am

Re: SQL ERROR [ mysql4 ]

Post by fahad4x4 »

Welcome

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

Return to “[3.0.x] Support Forum”