SQL ERROR [ mysql4 ]
Posted: 15. December 2008 16:11
Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.exalted-aoc.com/forums
PHP Version: 3.0.2
What have you done before the problem was there?
Installed the Codeblack Style (Subsilver based) and edited the css.
What have you already tryed to solve the problem?
Searched the Knowledge base here on these forums and looked through all 25 pages at php.com. And found out that if I kept the Install folder it would load the portal, but the portal is telling me to remove the directory. If I remove it it will show the following error
Description and Message
Hi,
I have just installed your portal, but am getting this error after having ran the install.php file:
The error only occurs if I remove the install directory.
I am able to use the administrator page for the portal, but the site will not show.
Hopefully you can help me out here as I've heard nothing but good about your portal
The forum is empty and holds a partial import of an old phpbb2 forum.
Also; As my theme is Subsilver based (I don't know if that is the reason) I can not find where to edit my changes in the overall_header and footer. [/i]
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.exalted-aoc.com/forums
PHP Version: 3.0.2
What have you done before the problem was there?
Installed the Codeblack Style (Subsilver based) and edited the css.
What have you already tryed to solve the problem?
Searched the Knowledge base here on these forums and looked through all 25 pages at php.com. And found out that if I kept the Install folder it would load the portal, but the portal is telling me to remove the directory. If I remove it it will show the following error
Description and Message
Hi,
I have just installed your portal, but am getting this error after having ran the install.php file:
The error only occurs if I remove the install directory.
Code: Select all
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 in_message = 0 ORDER BY filetime DESC' at line 4 [1064]
SQL
SELECT * FROM phpbb3_attachments WHERE post_msg_id = AND in_message = 0 ORDER BY filetime DESC
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: portal/includes/functions.php
LINE: 283
CALL: dbal_mysql->sql_query()
FILE: portal/block/announcements.php
LINE: 27
CALL: phpbb_fetch_posts()
FILE: portal.php
LINE: 107
CALL: include('portal/block/announcements.php')
Hopefully you can help me out here as I've heard nothing but good about your portal
The forum is empty and holds a partial import of an old phpbb2 forum.
Also; As my theme is Subsilver based (I don't know if that is the reason) I can not find where to edit my changes in the overall_header and footer. [/i]