• Registered: 2004-07-01
  • Posts: 4

Topic: Syntax Error...

Hello,

Sorry for language error, i'm French...
I've an error... can you help me please :

Line: 129
PunBB reported: Unable to fetch topic list for forum
Database reported: Erreur de syntaxe près de 'ORDER BY sticky DESC, last_post DESC LIMIT 0, 30' à la ligne 1 (Errno: 1064)

So i've write the line as say in this topic :
http://punbb.org/forums/viewtopic.php?id=2696&p=1

and the return is :
SELECT DISTINCT p.poster_id AS hasposted, t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to FROM rdetopics AS t LEFT JOIN rdeposts AS p ON t.id=p.topic_id AND p.poster_id= WHERE t.id IN() ORDER BY sticky DESC, last_post DESC

My server configuration is :
PunBB 1.1.4
Developed by Rickard Andersson
© Copyright 2002, 2003, 2004 Rickard Andersson
UNIX load averages       Not available (1 users online)
Environment       Operating system: Linux
PHP: 4.3.6 - Show info
Accelerator: N/A   
Database       MySQL 4.0.16-standard
Rows: 11610

thanks

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Syntax Error...

You must have made some modification to the code. For some reason, the value of $cur_user['id'] is null. I have no idea why.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-07-01
  • Posts: 4

Re: Syntax Error...

Thanks for reply !

So I tested the $cur_user['id'] and is null !  ;-)

Can you tell me if the config.php file can generate the problem.
I've not set the $cookie_domain... Is it because this ?

Should I modify the file "profile.php" ?

Thanks

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Syntax Error...

No, config.php doesn't affect that. Have you modified any of the files? Try uploading the scripts again. Also, just to be safe, try clearing your cookies.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-07-01
  • Posts: 4

Re: Syntax Error...

Thanks !

I'm going to do this.
(and yes, i've modified some files for personnalize my page...)

So if you want to see my website, go to http://www.ruedesenfants.com/forumrde/
(in development...)
That'is the forum, but perhaps i've made too many modifications in your files.

(but it works on my local computer... :-(  )

The cookies are not responsable (I've made some test on others platform and computers = same results)

So I will try to install forum in basic install on my server, and I will see.
I will post a reply for information if you want. (platform compatibilities...)

My htaccess can do a bad thing... I will see this to !

Thanks for your work, and for reply   ;-)
The forum is great !

  • Registered: 2004-07-01
  • Posts: 4

Re: Syntax Error...

So I've found the problem.

I don't do use multiple include (from header.php, footer.php...).
header.php call another script and this call another one...

(I don't know exactly why... and where...)
It don't work on Linux but on windows yes ... (CAPS ???)

So it work fine !

Bye and good work !