Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Coding Forum


You are currently viewing our Coding Forum as a guest. Please register to participate.
Login



Reply
Old 10-31-2011, 03:36 AM PHPBBB3 - php error
Junior Talker

Posts: 2
Trades: 0
Need Help.

I had PHPBB3 ver 3.0.8
Then i made MOD implement. Forum_sort_order from
phpbb. com /community/ viewtopic.php?t=587765

Then any new threads did not appear in the forum only it showed when i sort it by Descending - i thought it was some bug

Immediatelly i did upgrade the Forum to 3.0.9 and now it worse.

i get the message in the viewforum.php
bodyworks .pl /b-forum/ viewforum.php?f=3



Code:
SQL ERROR [ mysqli ]

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 'ASC  LIMIT 25' at line 7 [1064]

SQL

SELECT t.topic_id     FROM bf_topics t     WHERE t.forum_id = 3         AND t.topic_type IN (0, 1)                       ORDER BY t.topic_type DESC,  ASC  LIMIT 25

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: viewforum.php
LINE: 439
CALL: dbal->sql_query_limit()
Can Anybody help me fix it ?
i can provide FTP access.
Mildas is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 10-31-2011, 10:19 AM Re: PHPBBB3 - php error
chrishirst's Avatar
Defies a Status

Posts: 43,949
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Quote:
Then any new threads did not appear in the forum only it showed when i sort it by Descending
And did you look at the BOTTOM of the thread list when sorted in ascending order?
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-31-2011, 10:23 AM Re: PHPBBB3 - php error
chrishirst's Avatar
Defies a Status

Posts: 43,949
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
AND wouldn't you be better asking this question in the PHPBB support forums?
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?

Last edited by chrishirst; 10-31-2011 at 01:33 PM..
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-31-2011, 11:35 AM Re: PHPBBB3 - php error
Junior Talker

Posts: 2
Trades: 0
Yes Sorry i will go to PHPBB forum
Mildas is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to PHPBBB3 - php error
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.15386 seconds with 11 queries