SQL ERROR [ mysql4 ]

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
wood72
Active Member
Posts: 5
Joined: 12. December 2008 12:59

SQL ERROR [ mysql4 ]

Post by wood72 »

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.

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')
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]
User avatar

Heinrich-XIV
Tester
Posts: 233
Joined: 16. May 2008 18:39
phpBB.de User: Heinze 1906
phpBB.com User: Heinrich-XIV
Location: 52353 Düren

Re: SQL ERROR [ mysql4 ]

Post by Heinrich-XIV »

Hello

Please use the search function here with "SQL ERROR [ mysql4 ]". You will find many about this.


Greats

heinrich
Locked

Return to “board3 Portal 1.0.x - English Support”