gman2 Posted May 2, 2006 Share Posted May 2, 2006 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.tidSQL 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 3SQL 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.18Does anyone know how I could fix this? I really need this sorted so any help would be really gratefully received. Link to comment https://forums.phpfreaks.com/topic/8906-problem-with-ipb-mod/ Share on other sites More sharing options...
gman2 Posted May 2, 2006 Author Share Posted May 2, 2006 Anyone know? I'm not a PHP guy and need to move my site ASAP :( Thanks guys. Link to comment https://forums.phpfreaks.com/topic/8906-problem-with-ipb-mod/#findComment-32743 Share on other sites More sharing options...
ober Posted May 2, 2006 Share Posted May 2, 2006 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. Link to comment https://forums.phpfreaks.com/topic/8906-problem-with-ipb-mod/#findComment-32746 Share on other sites More sharing options...
Recommended Posts