Errors after upgrade

[kellyandmark04]

Just upgraded from 3.8 to 4 now with the hook system enabled I get

Fatal error: Call to a member function is_cloud_cachable() on a non-object in /home/XXX/public_html/includes/functions_search.php on line 537

With it disabled I get

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 1

And none of my notifications\private messages work also new posts says there are no new posts even after I have posted. And I am using the vb4 default style.

Also when I click a forum name

Invalid Forum specified. If you followed a valid link, please notify the administrator

Thanks in advance.

[Lynne]

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[kellyandmark04]

With it disabled I get

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 1

And none of my notifications\private messages work also new posts says there are no new posts even after I have posted. And I am using the vb4 default style.

Also when I click a forum name

Invalid Forum specified. If you followed a valid link, please notify the administrator

[Lynne]

Did you go through and do all the update counters that you were told to do after the upgrade?

[kellyandmark04]

I ran almost all the update counters successfully, but when I try and run the rebuild search index I get

Warning: array_shift() [function.array-shift]: The argument should be an array in [path]/admincp/misc.php on line 143

Fatal error: Call to a member function get_max_id() on a non-object in /home/XXX/public_html/admincp/misc.php on line 161

and still no change in the other errors.

[Lynne]

If you have ticket support, I would put in a ticket.

Otherwise, go to maintenance > diagnostics > suspect file version... do any *default* vbulletin files get listed there (I don't want to here about modification files)?

What version of php and mysql are you running?

[kellyandmark04]

Well I deleted vbSEO and now I can get into the forums and threads but if I try to create a new thread or click go advance on a post I get the error below also I still can't get into private messages. New posts don't show up in search either.



Invalid SQL:

SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = '23b3b203006579550653d6ee2396eadb'
AND
a.userid IN (1)
AND
a.contenttypeid =

ORDER BY a.contentid, a.displayorder;

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 'ORDER BY a.contentid, a.displayorder' at line 15

Here is the error from trying to access my inbox


Invalid SQL:
();

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 1


and no ticket support unfortunately and no suspect files. Thanks for all your help this has me completely lost as to why this is happening.

--------------- Added 1316218746 at 1316218746 ---------------

MySQL Version 5.0.92-community

[Lynne]

This is still with your plugins disabled via the config.php file?

When you removed vbseo, did you make sure to also remove the .htaccess you needed to add for it? Did you get any errors when running the upgrade script? Now that vbseo is removed and the .htaccess file is removed, try running the upgrade.php script again.

[kellyandmark04]

^^^Yes just ran the script no errors now when I try to post a new thread I get

Invalid SQL:

SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = 'da895c1fd4bf0773d6fa2d90308b3436'
AND
a.userid IN (1)
AND
a.contenttypeid =

ORDER BY a.contentid, a.displayorder;

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 'ORDER BY a.contentid, a.displayorder' at line 15
Error Number : 1064

[Lynne]

Do you have a contenttype table? How many rows are in it?

[kellyandmark04]

^^^Can you explain to me what that is and where it's located please? Thanks for all your help.

[Lynne]

It's a table in your database. Most people use some thing like phpMyAdmin to view their database and it's contents.

[kellyandmark04]

^^^I looked in the root and didn't see one.

[Lynne]

It isn't a file on your site - it's a table in your database. You may only view it if you use something like phpMyAdmin.

[kellyandmark04]

Ok I found it and opened it an it says

SELECT *
FROM `contenttype`
LIMIT 0 , 30

1 post
2 Thread
3 Forum
4 Announcement
5 SocialGroupMessge
6 SocialGroupDiscussion
7 SocialGroup
8 Album
9 Picture
10 PictureComment
11 VisitorMessage
12 User
13 Event
14 Calendar
15 BlogEntry
16 BlogComment
17 BlogDescription
18 BlogCustomBlock
19 Section
20 Article
21 ContentNode
22 StaticPage
23 PhpEval
24 ArticleComment

[Lynne]

If you have those article and blog type contenttypes, then it sounds like you have the Suite. If you have the suite, then you have ticket support. I would strongly suggest you put in a ticket for this.