General error

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
baggiesmad
Registered User
Posts: 167
Joined: Wed Jun 22, 2005 10:32 am

General error

Post by baggiesmad »

Got this error after finishing the installaton.
General Error
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 right_id < ORDER BY right_id DESC LIMIT 4' at line 5 [1064]

SQL

SELECT module_id, left_id, right_id, module_langname FROM phpbb_modules WHERE module_class = 'acp' AND parent_id = AND right_id < ORDER BY right_id DESC LIMIT 4

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 180
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 135
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/acp/acp_modules.php
LINE: 981
CALL: dbal_mysql->sql_query_limit()

FILE: install/install_install.php
LINE: 1581
CALL: acp_modules->move_module_by()

FILE: install/install_install.php
LINE: 104
CALL: install_install->add_modules()

FILE: install/index.php
LINE: 336
CALL: install_install->main()

FILE: install/index.php
LINE: 208
CALL: module->load()
any help would be great.
User avatar
Kieran007
Registered User
Posts: 273
Joined: Sun Aug 29, 2004 9:28 am
Location: London, UK
Name: Kieran O'Shea
Contact:

Re: General error

Post by Kieran007 »

What version of MySQL are you running on your server?
Kieran
[ RouterTech - Tech Support for all things networking ]
Useful phpBB links: Use the Forum Search!
No support via PM, please ask your questions in the forum!
baggiesmad
Registered User
Posts: 167
Joined: Wed Jun 22, 2005 10:32 am

Re: General error

Post by baggiesmad »

Im running

4.1.21-standard
User avatar
Kieran007
Registered User
Posts: 273
Joined: Sun Aug 29, 2004 9:28 am
Location: London, UK
Name: Kieran O'Shea
Contact:

Re: General error

Post by Kieran007 »

Well that version is supported by Olympus so thats ok.

Your problem however seems to be the actual query. If you note that parent_id has not been given a value in the query executed and so it has thrown an error.

Is this error something you continue to see (or ones like it) or can you use the forum install fine now? If you continue to see it (or even if you don't) I would venture to say that the problem was most likely caused by one of the files you uploaded not being written correctly and so not providing some of the data to make the query complete. This is likely to crop up again and cause problems so I would try a re-install, taking care that all the files upload correctly. If you have a flakey connection and have SSH access to your server you could try uploading the .tar file and untaring it server-side for the install.
Kieran
[ RouterTech - Tech Support for all things networking ]
Useful phpBB links: Use the Forum Search!
No support via PM, please ask your questions in the forum!
baggiesmad
Registered User
Posts: 167
Joined: Wed Jun 22, 2005 10:32 am

Re: General error

Post by baggiesmad »

Kieran007 wrote:Well that version is supported by Olympus so thats ok.

Your problem however seems to be the actual query. If you note that parent_id has not been given a value in the query executed and so it has thrown an error.

Is this error something you continue to see (or ones like it) or can you use the forum install fine now? If you continue to see it (or even if you don't) I would venture to say that the problem was most likely caused by one of the files you uploaded not being written correctly and so not providing some of the data to make the query complete. This is likely to crop up again and cause problems so I would try a re-install, taking care that all the files upload correctly. If you have a flakey connection and have SSH access to your server you could try uploading the .tar file and untaring it server-side for the install.
Thanks for the help,

I will try a reinstall today and let you know the outcome. :)
Locked

Return to “[3.0.x] Support Forum”