wierd problem with my forum please help its urgent

[aapkae]

Hi guys, I did an upgrade to the site and now I have several problems;

1. The site it should be www.xxxxx.com/index.php now is www.xxxx/.php (the index word is missing, how can I fix this?)

2. The Plugin and Products have a problem as well, it says this:

Warning: Plugins are currently globally disabled in your options. In order for plugins and products to function correctly, you must enable the plugin system. Importing a product will do this for you automatically.

However when you click on the link nothing happens, not even trying to importing a product, and what is more, there is no Plugins and Product option from the forum options.

3. If I trick the site and put index.php I have this error if try to enter to any forum.
4.i cannot see vbulletin options>>plugin/hook sys options also.while in other forums i can see it(other sites of mine)

Database error in vBulletin 3.8.3:

Invalid SQL:

		SELECT  thread.threadid,
			thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
			
		FROM thread AS thread
		
		
		WHERE forumid = 24
			AND sticky = 0
			
			 AND visible IN (0,1,2)
			
			
			
			
		ORDER BY sticky DESC, lastpost DESC
		LIMIT 0,;

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 '' at line 16
Error Number  : 1064
Request Date  : Tuesday, December 29th 2009 @ 06:14:27 PM
Error Date    : Tuesday, December 29th 2009 @ 06:14:27 PM
Script        : http://www.vvvvv.net/forum/forumdisplay.php?f=24
Referrer      : http://www.vvvv.net/forum/forumdisplay.php?f=6
Username      : admin
Classname     : vb_database
MySQL Version : 4.1.22-standard

[snakes1100]

1. import backup of database before upgrade.
2. uninstall conflicting hack/addon that is causing the upgrade to fail.

You shouldn't have to re-upload the previous php files for the older version, you should be able to get into the admincp with the newer files there.

[aapkae]

i can get inside the admin panel.i have uninstalled all the addons,but problem is still there.i m not able to see any forum on main page

[snakes1100]

Try step #1 in my 1st post.

[aapkae]

i m not able to upgrade,due to older version of php on my site

--------------- Added [DATE]1262160970[/DATE] at [TIME]1262160970[/TIME] ---------------

no one is here to help?

--------------- Added [DATE]1262173880[/DATE] at [TIME]1262173880[/TIME] ---------------

still problem is same ....

[aapkae]

no one here to solve this problem ..... my forum is closed from one week ... no one here to solve this

[Lynne]

1. Check vboptions > site name or check your htaccess file

2. Did you disable them in the config.php file? Do you have this in there?

PHP Code:

define('DISABLE_HOOKS', true); 


Set it to false to turn them back on.

[aapkae]

there is no line like this.i did not add any

[Lynne]

OK, then look to see if you disabled them in options > plugin/hook system

And, if not there, then look to see if you disabled the individual products in Plugins & Products > Manage Products

And, if not there, then look to see if you disabled the individual plugins in Plugins & Products > Plugin Manager.

[aapkae]

OK, then look to see if you disabled them in options > plugin/hook system

wierd thing is that i cannot see this option in my vbulletin board just for this forum.but for other forums i can see it.and for rest of 2 solutions.i did remove all the plugins and still it is same

--------------- Added [DATE]1262461238[/DATE] at [TIME]1262461238[/TIME] ---------------

when we delete spamming users then the other error is

Warning: Division by zero in [path]/includes/functions.php on line 2398