Jump to content


Problem with IPB mod

  • This topic is locked This topic is locked
2 replies to this topic

#1 gman2

  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 02 May 2006 - 05:09 PM

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.

#2 gman2

  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 02 May 2006 - 08:05 PM

Anyone know? I'm not a PHP guy and need to move my site ASAP :(

Thanks guys.

#3 ober

  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 02 May 2006 - 08:09 PM

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.

Info: PHP Manual

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users