OpenCart Community

Posted: **Sun Feb 24, 2013 8:39 pm**

On OC 155.1
Upgrading from OC 154.1
Same errors on Wamp & UniformServer.

Warning: strpos() [function.strpos]: Empty delimiter in C:\Wamp\www\catalog\controller\common\header.php on line 70

I have seen the above error on the bug list topic for 155, but could not locate a fix?

Also, Admin/settings won't let me save anything, returns def. error:
Warning: Please check the form carefully for errors!
Nothing showing up in error logs for this.

Followed all the readme/upgrade text before coming here,

We have a live shop, with over 1k products.
I tried running thru both the upgrade script to manually with phpmyadmin,
Same errors.

Any help would be greatly appreciated.

Thanks.

Posted: **Sun Feb 24, 2013 8:48 pm**

Probably you haven't last opencart release, because in line 70 no strpos reference. Can you replay here what you have on line 70 of quoted file.

Posted: **Sun Feb 24, 2013 9:14 pm**

Odd, we only downloaded the 155.1 a few days ago...

Thx for ur response,

Code: Select all

if (strpos($this->request->server['HTTP_USER_AGENT'], trim($robot)) !== false) {

Posted: **Sun Feb 24, 2013 9:39 pm**

Wow, just re-downloaded the SAME zip, 155.1 and code has changed but release date not...rly?

Edit:
makes me wonder now if I should just redo everything, I guess so,
Seems as tho this could have been avoided with clearer release dates or version numbers..

Edit 2:
No more header.php error.
But still can't save in admin/settings.

Any ideas?

Thanks!

Posted: **Sun Feb 24, 2013 10:19 pm**

New error upon re-running the upgrade script:

Code: Select all

Notice: Error: Column 'description' cannot be part of FULLTEXT index<br />Error No: 1283<br />ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` in C:\Wamp\www\system\database\mysql.php on line 50

I am lost now.

Posted: **Wed Feb 27, 2013 4:16 am**

Hi,

I am also getting this error.

Can anyone help?

Posted: **Wed Feb 27, 2013 6:43 pm**

Sigh, "community support" where is it guys?

Not sure if the mods even visit this forum.

3 topics with the same error, lots of ppl with the same error, nada!

Posted: **Mon Mar 25, 2013 4:38 am**

Any one fixed this yet?

Any help would be good.

Cheers Jimmy

Posted: **Wed Mar 27, 2013 11:25 am**

Welcome to wamp. On local machines, try installing even on Win the real thing, Apache plus mysql itself plus php (etc.) themselves. Binaries for Win are compiled for each; just as binaries are compiled for flavors of Linux and Unix. Compilers are v. fussy; they ordinarily get it right and ordinarily you'll see "stable" releases as well as successor releases that are still in development.

However, on public production boxes, where the stable real deal should already be resident (Linux, Win, alike), as a practical matter it can be well worth downloading a few times, hours or days apart, and ensuring that files are consistent before using them. There could be packet errors in downloading, there could be sudden quickfixes after proofreading, whatever. There's no encryption confirmation of the packages, so live with that part.

The admin panel's admonition upon saving to look for errors can be frustrating if they're not immediately self-evident, and occasionally it seems to spring from nowhere. The admin panel is fussy about all of the boxes.

Also: on production boxes, php and cart error reporting/displaying, but not logging, should be shut off except during purposeful testing. What they show is all too often not appropriate for the big world to see.

Posted: **Sat Apr 27, 2013 1:11 am**

I also had such error:

Code: Select all

Notice: Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` ...

So i solved it by googling about "cannot be part of FULLTEXT index"

And here are my results:
http://stackoverflow.com/questions/1330 ... o-fulltext
so fields in product_description are in
utf8_bin
but the table has not the same collation (utf8_general_ci or some other _ci)

So what i did, i manually runned such query:

Code: Select all

ALTER TABLE <YOUR DB_PREFIX>product_description CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin

And after that badass querry

Code: Select all

ALTER TABLE `<YOUR DB_PREFIX>product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id`

And it whent good. But it not so easy at must be, i must change the upgrade model class in install folder.

Ive done this changes in /install/module/update.php:
In line 169 before line of code

Code: Select all

if (isset($table['option']['CHARSET']) && isset($table['option']['COLLATE'])) {

i placed

Code: Select all

if($table['name'] == '<YOUR DB_PREFIX>product_description') {
	$table['option']['COLLATE'] = 'utf8_bin'
}

And then i had second error!

But fixed the same way:

after previous change in line near 246 (original 242) after code of line

Code: Select all

if ($result['Key_name'] != 'PRIMARY') {

i placed

Code: Select all

if($result['Key_name'] == 'ft_namerel') continue;

And UPGRADE WAS DONE!

I used 1.5.5.1 upgrade onto 1.5.3.1 OpenCart version

P.S.: Sorry for my English...

Posted: **Mon May 06, 2013 10:37 am**

Thanks so much.
It worked with me./

Posted: **Sat Jun 15, 2013 3:07 am**

Hi,

Just trying to perform upgrade from 1.5.3 to 1.5.5.1 and I am also receiving the error
Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` in /home/a/m/dbname/public_html/system/database/mysql.php on line 50

Tried the above recommendations but still receiving error.

Posted: **Mon Jun 17, 2013 4:24 am**

I have been wracking my brain trying to figure out these errors with the upgrade. I was not able to get cosname's solution to work. After Googling the errors I continued to receive, I FINALLY figured out. The solution cosname posted is indeed correct, however, there was a semicolon missing from one of the edits. Here is the updated fix:

In phpmyadmin run this query:

Code: Select all

ALTER TABLE <YOUR DB_PREFIX>product_description CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin

Then run this query:

Code: Select all

ALTER TABLE `<YOUR DB_PREFIX>product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id`

In file: /install/model/update.php:
Find this code (line 169)

Code: Select all

if (isset($table['option']['CHARSET']) && isset($table['option']['COLLATE'])) {

Then insert this code before it:

Code: Select all

    if($table['name'] == '<YOUR DB_PREFIX>product_description') {
       $table['option']['COLLATE'] = 'utf8_bin';
    }

Around line 246, find:

Code: Select all

    if ($result['Key_name'] != 'PRIMARY') {

Then place this code after it:

Code: Select all

    if($result['Key_name'] == 'ft_namerel') continue;

That fixed it for me. All credit goes to cosname for the fix. I sincerely appreciate your post for the fix and thanks again! There was just one semicolon that was missing. Hope this helps anyone out who has been as frustrated as I have trying to get the 154 to 155 update to work.

Posted: **Fri Nov 01, 2013 8:31 pm**

Thanks @cosname , it worked for me!

I had the same error, when upgrading for a client from 1.5.5.1 to 1.5.6.

Code: Select all

Notice: Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` ...

This is not my first upgrade from 1.5.5.1 to 1.5.6, but it was the first time I had these errors showing up. I assume that the client had a previous update from a lower version to 1.5.5.1 and it was not done right.

Saved my day.

Thanks again,
Andy

Posted: **Sat Dec 21, 2013 11:00 am**

Just above recap of Error No. 1064 at http://forum.opencart.com/viewtopic.php ... on#p434624 is a downloadable modified script for upgrading to 1.5.6.0 -- while we're awaiting the 1.5.6.1 release. The occurrences of Error No. 1283 above seem relatively more infrequent (1064 is not rampant) but the amended script should prevent that, too. Slight changes in .zip contents without visible renumbering of packages can be safeguarded against by setting safely aside downloaded packages that do work (and noting their timestamps, perhaps in amended .zip names), rather than happening to overwrite them.

Posted: **Mon Feb 03, 2014 6:25 am**

Thanks, saved me too.

I was just in doubt about my DB_PREFIX, but i checked on my config.php that there wasnt NO DB PREFIX on my installation, so i just removed this part on the fix you posted... and then.. ALL FINE!

Thanks a lot!

OpenCart Community

Upgrade 154.1 to 155.1 - Error No: 1283

Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Errors.

Re: Upgrade 154.1 to 155.1 - Errors.

Re: Upgrade 154.1 to 155.1 - Errors.

Re: Upgrade 154.1 to 155.1 - Errors.

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283

Re: Upgrade 154.1 to 155.1 - Error No: 1283