?
avatar joeyadams
joeyadams
2 Oct 2014

I get the following message when I try to upgrade Joomla from 2.5.18 to 3.3.6 under MySQL 5.1 and IIS 8:

Fatal error: Call to undefined method RuntimeException::get() in C:\inetpub\wwwroot\libraries\joomla\error\error.php on line 803

MySQL 5.1+ is listed as the minimum and recommended version for Joomla 3.x in Technical Requirements.

By looking at logs/joomla_update.php, I saw that it stopped on update 3.1.0. When I run the SQL updates manually (replacing #_ with jos) on a 2.5.18 database, I get an error on the 3.1.0 update:

ERROR 1366 (HY000) at line 93: Incorrect integer value: '' for column 'created_user_id' at row 1

Here is the offending SQL command:

INSERT INTO `#__tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`,`created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`)
VALUES (1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '', '', '2011-01-01 00:00:01','', 0, '0000-00-00 00:00:00', '', '',  0, '*', 1);

The problem is in '', '2011-01-01 00:00:01'. It is supplying '' instead of 0 for the created_user_id. This command fails on MySQL 5.1, but succeeds on MySQL 5.5.

avatar joeyadams joeyadams - open - 2 Oct 2014
avatar shur
shur - comment - 2 Oct 2014

Incorrect integer value: '' in #__tags table

The same issue also present in joomla.sql file.
I fixed this already in my PR #4311 but it still pending.

avatar vdespa vdespa - change - 3 Oct 2014
Category SQL Updating
avatar nicksavov
nicksavov - comment - 16 Oct 2014

@joeyadams , thanks for reporting the issue! Please test Shur's proposed fix.

@shur , thanks for submitting the PR!

avatar nicksavov nicksavov - change - 16 Oct 2014
Labels Added: ?
avatar brianteeman brianteeman - change - 17 Oct 2014
Category SQL Updating IIS SQL Updating
avatar brianteeman brianteeman - change - 1 Jan 2015
Labels Removed: ?
avatar brianteeman
brianteeman - comment - 3 Jan 2015

In the absence of any repsonse I am closing this as a duplicate report of #4311


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4437.
avatar brianteeman brianteeman - change - 3 Jan 2015
Status New Duplicate Report
Closed_Date 0000-00-00 00:00:00 2015-01-03 01:31:11
Closed_By brianteeman
avatar zero-24 zero-24 - close - 3 Jan 2015
avatar zero-24 zero-24 - close - 3 Jan 2015
avatar brianteeman brianteeman - close - 3 Jan 2015
avatar brianteeman brianteeman - change - 3 Jan 2015
Closed_Date 2015-01-03 01:31:11 2015-01-03 01:31:12
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment