Post by CrossCore » Sun Feb 24, 2013 8:39 pm

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

Code: Select all

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.
Last edited by CrossCore on Sun Feb 24, 2013 10:23 pm, edited 1 time in total.

Newbie

Posts

Joined
Mon Feb 18, 2013 7:54 pm

Post by palex » 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.

AnyList extension (free) - Stop clone "featured", now you can display product selections anywhere
Send Cart - Let's visitors (incl.anonymous) to send your cart by email and restore it for later use
Cross Sell - Sell more on each visitor with automatic suggestion of more products
Advanced Search - Adaptive search by everything (attributes, sku, ean, jpc, isbn etc.)


New member

Posts

Joined
Tue Oct 30, 2012 1:36 am

Post by CrossCore » 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) {

Newbie

Posts

Joined
Mon Feb 18, 2013 7:54 pm

Post by CrossCore » 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!

Newbie

Posts

Joined
Mon Feb 18, 2013 7:54 pm

Post by CrossCore » 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.

Newbie

Posts

Joined
Mon Feb 18, 2013 7:54 pm

Post by redjan » Wed Feb 27, 2013 4:16 am

Hi,

I am also getting this error.

Can anyone help?

Newbie

Posts

Joined
Wed Feb 27, 2013 3:49 am

Post by CrossCore » 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!

Newbie

Posts

Joined
Mon Feb 18, 2013 7:54 pm

Post by jimmyharwood » Mon Mar 25, 2013 4:38 am

Any one fixed this yet?

Any help would be good.

Cheers Jimmy

New member

Posts

Joined
Thu Dec 29, 2011 12:55 am

Post by butte » 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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by cosname » 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...
Last edited by cosname on Thu May 16, 2013 11:49 pm, edited 1 time in total.

Newbie

Posts

Joined
Sat Apr 27, 2013 12:59 am

Post by ceongroup » Mon May 06, 2013 10:37 am

Thanks so much.
It worked with me./

Newbie

Posts

Joined
Tue Dec 27, 2011 11:56 am

Post by ampgit » 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.

Newbie

Posts

Joined
Wed Sep 12, 2012 8:01 pm

Post by png22 » 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.

;)

User avatar
Newbie

Posts

Joined
Tue Jun 05, 2012 7:19 am

Post by andrei.bogdan » 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

Andrei
andrei.opencart[at]yahoo.com
Themes and Extensions


Active Member

Posts

Joined
Mon Mar 25, 2013 4:52 am

Post by butte » 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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by luizeduardo » 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!

New member

Posts

Joined
Tue Jul 03, 2012 4:01 am
Who is online

Users browsing this forum: No registered users and 40 guests