Jump to content


This topic is now archived and is closed to further replies.


Problem with IPB mod

Recommended Posts

Hey guys,

I've moved my invision database to a new server, it's not corrupt and I've verified this. However when I load the index page, which is set to point to index.php?act=uportal I get the following;

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]IPB WARNING [2] mktime() expects parameter 4 to be long, string given (Line: 1140 of /sources/action_public/uportal.php)

mySQL query error: SELECT COUNT(DISTINCT(t.tid)) as tcnt,
COUNT(DISTINCT(p.pid)) as pcnt FROM ibf_posts p, ibf_topics t WHERE
p.post_date > AND p.topic_id=t.tid

SQL error: 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 p.topic_id=t.tid' at line 3
SQL error code:
Date: Tuesday 02nd 2006f May 2006 10:49:26 AM[/quote]

Now I know this isn't a problem with the topics or posts as index.php?act=idx works perfectly, it however seems that the MySQL server is interpreting this code as wrong syntax. The MySQL version is: 4.1.18

Does anyone know how I could fix this? I really need this sorted so any help would be really gratefully received.

Share this post

Link to post
Share on other sites
Anyone know? I'm not a PHP guy and need to move my site ASAP :(

Thanks guys.

Share this post

Link to post
Share on other sites
Posting about a third-party script AND bumping. Thread closed. If you want to post again, post in the 3rd party scripts board.

I suggest you contact IPB about the problem.

Share this post

Link to post
Share on other sites
This topic is now closed to further replies.


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.