need help members get a sql error but i can see my forum
 

this is weird and i dont get it.

i have been doing changes to my board but i and a few can only see it. everyone else gets this

There seems to have been a slight problem with the Lowandloud.com Forums:. IDEN HQ database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

but i can browse and post etc. 90% of my members are getting this error. why? is it something i did. i did use an old database of mine with a new board. if youve seen this before let me know what to do and how to fix it.

my site is www.lowandloud.com please let me know what you see as well if you can help. thanks ahead of time

Please do a right click and view source on that error page.

It will show you the full SQL error. Post that here.

Lol, had a look myself. You are trying to integrate phpbb and vB:
Anyhow, the error is that you are using an variable instead of a normal one or: You'll have to fix that. Can't help you more unless you post the lines from your php script.

edit: Actually your are redirecting to a phpbb page. Maybe you should ask in their support board ;)

its not phpbb i just left the folder named that when i started over with VB from phpbb. i should have changed it but i didnt want to mess anything up.

i dont know what to change and i cant get the source code casue i dont get the errors my members do. but i will ask one to post it or try from another PC to see what i get. but i see my forum on my PC with no issues. i dont get it

and this is an email im getting i have around 250 of em all the same

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT

thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview

FROM smora_thread as thread
LEFT JOIN smora_icon USING (iconid)
LEFT JOIN smora_forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN smora_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN smora_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(1,2,4,58,59,15,26,27,45,60,28,31,3,5,46,47,48,4 9,6,7,9,11,12,14,10,16,17,18,24,30,41,8,29,37,19,3 8,42,32,54,43,50,25,44,23,55,35,56,36,57,53,34,52, 39,40,20,21,22) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10

mysql 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 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost D

mysql error number: 1064

Date: Wednesday 16th of February 2005 01:12:10 AM
Script: http://www.lowandloud.com/phpbb2/index.php
Referer:
Username: Unregistered
IP Address: 66.135.140.240

Yes, that is like i replied above. Without knowing what modifications you made i can't help you.

I think you made some changes to forumdisplay.php. Post the changed code containing this query here, and i will have a look. Alternative would be to revert back to original sources.

Edit: this query will probably around line 660 of forumdisplay.php

Create a test account that has the same permissions as your members. It might be a usergroup related thing or it might be based on some data that's in your user profile and not theirs.

the old board had u cash , whos been online for last 24, recent ban list,files list,cmps portal,email.php, affiliates hack. those are it. i dont remember changing the forum display.php. i logged out of the forum and went to the portal page and thats the only one that gives this error. the forum wich is marked index1.php is fine for not registered and regular members. but the portal is the first page everyone gets. so what can be the issue. im looking at the forum display but dont get it.