Can't show news

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
origon
Active Member
Posts: 4
Joined: 24. October 2008 21:52

Can't show news

Post by origon »

Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner
Boardlink: http://igames.origon.dk

PHP Version: 5.2.8
MySQL Version: 4.1.22

What have you done before the problem was there?
I was updating the ultimate points mod, and i got a problem with functions.php and functions_posting-php i had to insert 2 new files

What have you already tryed to solve the problem?
Edit the 2 files i changed

Description and Message
When i'm inserting the news in acp, i'm getting this error in the portal

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 in_message = 0 ORDER BY filetime DESC' at line 4 [1064]

SQL

SELECT * FROM phpbb_attachments WHERE post_msg_id = AND in_message = 0 ORDER BY filetime DESC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: portal/includes/functions.php
LINE: 283
CALL: dbal_mysql->sql_query()

FILE: portal/block/news.php
LINE: 30
CALL: phpbb_fetch_posts()

FILE: portal.php
LINE: 115
CALL: include('portal/block/news.php')
[/i]
Locked

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