PDA

View Full Version : good morning


ellinofatsa
04-15-2010, 07:44 AM
i hope its the richt place here!!!
today i go to my mail and i see many of mails from my board !!

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
FROM post as post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE post.visible = '1' AND thread.forumid NOT IN(138,141,150,142,) AND post.dateline >= 1271317377
GROUP BY post.threadid;

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 ') AND post.dateline >= 1271317377
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, April 15th 2010 @ 11:37:59 AM
Error Date : Thursday, April 15th 2010 @ 11:37:59 AM

how can i fix the dataerror?
thanks.

Videx
04-16-2010, 03:07 AM
Uninstall ALL of your modifications and any files you may have uploaded for them. Be sure to revert ALL your templates. Also uninstall any non-default styles you may have.

After running a forum for a couple of years you may be ready to install some simple mods. One at a time.

Lynne
04-16-2010, 04:21 AM
Instead of uninstalling all your mods, try just disabling them and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

ellinofatsa
04-16-2010, 10:41 AM
ok thanks i try it out

Videx
04-16-2010, 10:56 AM
Of course, the problem with this approach is that it will not disable any bad template edits you have done (or 'good' ones for that matter). And I don't think it will disable files you have uploaded.

ellinofatsa
04-16-2010, 11:07 AM
i have anather problem i cant see my portal.
is that inbosible?

can you help?

Lynne
04-16-2010, 01:56 PM
If you disabled your plugins by the method above, and your portal was a modification, then it won't show up again until you turn your modifications back on.

ellinofatsa
04-16-2010, 02:25 PM
bad i dont have see my portal from the first day.
i wont to ask how can i make my portal?
i dont now that hope you help!!

borbole
04-16-2010, 03:17 PM
Judging from this other thread, I think the OP wants to download and install a portal for his forum.

https://vborg.vbsupport.ru/showthread.php?t=240583