The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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 |
#2
|
|||
|
|||
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: Code:
Script: http://www.lowandloud.com/phpbb2/index.php Referer: https://vborg.vbsupport.ru/showthread.php?p=612608#post612608 PHP Code:
PHP Code:
edit: Actually your are redirecting to a phpbb page. Maybe you should ask in their support board |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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.
|
#6
|
||||
|
||||
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.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|