Upgrade from 1.10.3 to 1.11.1 - Fatal Error / Database Error

[jackstringer]

Evening all,

Upgrade from 1.10.3 to CMSMS 1.11.1

I have had an issue with 1 site after upgrade. I kept getting connection reset on the main page. But I can log into admin and all is well until I go to create a page or edit a page then I get,

Code: Select all

Fatal error: Class 'CMS_Content_block' not found in /var/www/vhosts/midwesthusaberg.co.uk/httpdocs/lib/classes/contenttypes/Content.inc.php on line 468

Files verified correctly and upgrade.php ran fine.

From what I can tell from testing (going back to my backups and re-installing) I seem to have an error in the sql database. I managed to upgrade from CMSMS 1.10.3 "Hyacinthe" to 1.11.1 fine and can edit/read pages in Admin but the site main page just ends up with connection reset (time outs). If I run repair it mentions 'site prefs' table then once repair is done I can't edit or create pages in the admin getting the above fatal error. If I try to repair before upgrading I break the site getting the connection reset error (on 1.10.3).

Using notepad++ there is not much of a difference in the SQL dumps so I am at a loss to as what causes the issue. I can guess that I have an error in the database but I don't know if any of my backups have a copy of the database before the error.

Is there a way to work out what the error is an correct it via MyPHPAdmin? I can provide a SQL dump if someone can decipher it for me, I am a low level nerd...ie I can type HTML in notepad but I still use Windows.

[Dr.CSS]

We will need your system info first, what admin theme do you use, the old default doesn't work in the latest version of CMSMS...

[jackstringer]

what admin theme do you use?

Was using default but once I upgrade I changed to the new theme. As I noticed default has CSS issues with 1.11.1

your system info

Code: Select all

PHP Information
Current PHP Version (phpversion) 	Success 	 5.2.17
md5 function (md5_function) 	Success 	 On (True)
GD version (gd_version) 	Success 	 2
tempnam function (tempnam_function) 	Success 	 On (True)
Magic quotes in runtime (magic_quotes_runtime) 	Success 	 Off (False)
Is E_STRICT disabled in error_reporting (E_STRICT) 	Success 	
PHP Effective Memory Limit (memory_limit) 	Success 	 64M
Maximum Execution Time (max_execution_time) 	Success 	 60
PHP output_buffering (output_buffering) 	Success 	 4096
PHP Safe Mode (safe_mode) 	Success 	 Off (False)
File uploads (file_uploads) 	Success 	 On (True)
Maximum Post Size (post_max_size) 	Success 	 25M
Maximum Upload Size (upload_max_filesize) 	Success 	 10000M
Session Save Path (session_save_path) 	Caution 	 No check because open basedir active ?	
Sessions are allowed to use Cookies (session_use_cookies) 	Success 	 On (True)
Basic XML (expat) support (xml_function) 	Success 	 On (True)
Checking if the httpd process can create a file inside of a directory it created (create_dir_and_file) 	Success 	
PHP register_globals (register_globals) 	Success 	 Off (False)
disable_functions in PHP (disable_functions) 	Caution 	 , dl , passthru , pcntl_exec , pfsockopen , posix_kill , posix_mkfifo , posix_setuid , proc_close , proc_open , proc_terminate , system , leak , posix_setpgid , posix_setsid , proc_get_status , proc_nice , show_source ?	
PHP Open Basedir (open_basedir) 	Caution 	 /var/www/vhosts/midwesthusaberg.co.uk/httpdocs:/tmp ?	
Test for remote URL (test_remote_url) 	Success 	
fsockopen: Connection ok! Success
fopen: Connection ok! Success
Test ini_set (check_ini_set) 	Success 	 On (True)

Code: Select all

Server Information
Server API (server_api) 		apache2handler
Server Database (server_db_type) 		mysql (mysql)
Server Database Version (server_db_version) 	Success 	5.0.77
Server Software (server_software) 		apache
Server Operating System (server_os) 		linux 2.6.32-042stab039.11 on x86_64 

Code: Select all

CMS Install Information
CMS Version 		1.10.3

Code: Select all

Installed Modules
CMSMailer 		2.0.2
FileManager 		1.2.0
MenuManager 		1.7.7
ModuleManager 		1.5.3
News 		2.12.3
SiteMapMadeSimple 		1.2.6
Printing 		1.1.2
Search 		1.7
ThemeManager 		1.1.4
TinyMCE 		2.9.6
CGExtensions 		1.29.1
Gallery 		1.5.3
vimeoplayer 		1.1
youtubeplayer 		1.3.1
CMSPrinting 		1.0
MicroTiny 		1.1.1

Code: Select all

CMS Config Settings
php_memory_limit 		 
process_whole_template 		false
output_compression 		false
max_upload_size 		10000000000
default_upload_permission 		664
url_rewriting 		mod_rewrite
page_extension 		/
query_var 		page
image_manipulation_prog 		GD
auto_alias_content 		true
locale 		 
default_encoding 		utf-8
admin_encoding 		utf-8
set_names 		true
debug 		false 

[Dr.CSS]

I don't really know what all these mean but it doesn't look good...

disable_functions in PHP (disable_functions) Caution , dl , passthru , pcntl_exec , pfsockopen , posix_kill , posix_mkfifo , posix_setuid , proc_close , proc_open , proc_terminate , system , leak , posix_setpgid , posix_setsid , proc_get_status , proc_nice , show_source ?

You also have... page_extension /
that is not a page extension, for most servers that means a 'folder' as in mysite.com/images/...

[Jos]

all is well until I go to create a page or edit a page then I get,

Code: Select all

Fatal error: Class 'CMS_Content_block' not found in /var/www/vhosts/midwesthusaberg.co.uk/httpdocs/lib/classes/contenttypes/Content.inc.php on line 468

Files verified correctly and upgrade.php ran fine.

Maybe there is something wrong in your default page template? Some old smarty tag perhaps that isn't valid anymore?

[nosyguy]

I am having the same problem! The exception is mine is a new install. Install went fine as usual, then I went in to change the homepage from the default install and got this same error.

Any help out there?

[nosyguy]

Ah ha! Here is a clue and an update.... It only happens when the site down message is enabled!