Skocz do zawartości
Feronso

DB Error: (M23) Lofi - View New Posts

Polecane posty

Feronso    1

ok i understand. but if u release new version f this mod included with extra MSEO readme.html then it's very nice.

MSEO Mod available to every one u can download it to from minervaseo site OR IZE OR IM OR IPS and check what the codes they used :)

hey spanner h r u man ? recently i have installed Michael John mod here is link http://www.devfuse.com/forums/index.php?au...amp;showfile=38 and after this i have this error

===================================================

Date: Wed, 24 Jun 2009 03:06:35 -0400

Error Number: 1064

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 'ORDER BY t.last_post DESC LIMIT 0,25' at line 1

IP Address:

Page: /lofiversion/index.php?viewnew.html

mySQL query error: SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != 'link' AND t.forum_id IN(2,137,9,11,56,13,12,14,74,115,35,16,90,25,26,27,28,95,18,60,17,132,133,134,7

3,92,104,120,39,36,34,125,126,87,108,37,38,91,93,41,97,59,53,107,42,119,129,130,

1

31,80,64,86,51,47,48,123,52,57,96,67,135,128,94,106,105,127,85,121,136,124,112,1

1

3,114,63,117,118,55) AND t.last_post >  ORDER BY t.last_post DESC LIMIT 0,25

i have asked this to micahel and he said this error is not from his mod because he is not used any extra queries OR Database in his. so i see and found that the IDS 2,137 and more are in Google SIte Map seeting in TOOLS & SETTINGS so this error generate because your mod conflict with Michael Mod (M23) Lofi - View New Posts so is there any way to fix this problem ?

thanks you

Udostępnij ten post


Link to postu
Udostępnij na innych stronach
Spanner    4247

this is not problem with Google SiteMap Generator. I split topic and try You help.

Can You send me this mod ?? i try help you

Udostępnij ten post


Link to postu
Udostępnij na innych stronach
Feronso    1

but this all forums IDS i putted in google sitemap generator. then how can u know this error is not from GSMG ?

Udostępnij ten post


Link to postu
Udostępnij na innych stronach
Spanner    4247

hmm..

i installed this mod, installed Google SiteMap Generator and when I click View New Posts link in lofi Version i see all new post.

You have eror in

AND t.last_post >  ORDER BY t.last_post DESC LIMIT 0,25
this place. Probablyin code:
$ipsclass->DB->simple_construct( array( 'select' => 't.*, t.title as topic_title',
'from' => 'topics t',
'where' => "t.approved=1 AND t.state != 'link' AND t.forum_id IN($forums) AND t.last_post > {$last_time}",
'order' => "t.last_post DESC" ) );[/code]

where varible $last_time is null. check this code maybe you have some mistake

Udostępnij ten post


Link to postu
Udostępnij na innych stronach
Gość
Temat jest zablokowany i nie można w nim pisać.

  • Kto przegląda   0 użytkowników

    Brak zalogowanych użytkowników przeglądających tę stronę.

×

Ważne informacje

Kontynuując przeglądanie strony, wyrażasz zgodę na używanie przez nas plików cookies.