Can't show news
Posted: 16. August 2009 16:49
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
[/i]
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')