addons installation error

Permalink
Howdy

When I try to install an addon I get the following:

mysql error: [1048: Column 'btDisplayOrder' cannot be null] in EXECUTE("INSERT INTO BlockTypes(btID,btHandle,btName,btDescription,btActiveWhenAdded,btCopyWhenPropagate,btIncludeAll,btIsInternal,btInterfaceWidth,btInterfaceHeight,pkgID,btDisplayOrder) VALUES (NULL,'image_banner','Image Banner','A block that creates a banner by automatically resizing and cropping a selected series of images.',1,0,0,0,'550','500','21',NULL)")


If I do a manual install it won't save to cart or show up in marketplace to install list.

Thanks in advance!

Eulalia
 
adajad replied on at Permalink Reply
adajad
What version of c5 are you on? What version of the add-on are we talking about? Are they compatible?

Have you contacted the developer (mesuva) on the the add-on's page: http://www.concrete5.org/marketplace/addons/image-banner/... ?
Eulalia replied on at Permalink Reply
Eulalia
I'm using 5.5.2.1. I tried a number of addons to see if any would install, but an example would be vertical image spacer/margin. Havn't had any problems with addons before. Have installed free and purchased.
adajad replied on at Permalink Reply
adajad
My best guess is you have tried to upgrade your c5 installation to 5.6 and later downgraded for some reason. My assumption is based on the fact btDisplayOrder was added in 5.6 and wasn't present in 5.5.

You can do one of two things here:

1. Update your c5 to the latest stable version (5.6.0.2). This is the recommended fix.

2. Edit the database and delete the column btDisplayOrder in table BlockTypes (make sure you backup your database first). This might (but shouldn't) give unexpected results, so not recommended.
Eulalia replied on at Permalink Reply
Eulalia
Your right on with that. But that takes me to the problem that I have been researching and trying to get my head around before attempting again, updating. In spite of forum discussions, not up to speed on reinstalling database.

When I tried the update I lost the site, totally, and the only way to recover my site was to change the update line in config/site.php. back to 5.5.2.1

I have questions on this matter, so should I repost a different discussion or can you give me a hand here?
adajad replied on at Permalink Reply
adajad
Can you explain the update process that led to the lost site?
adajad replied on at Permalink Reply
adajad
Just found your other thread here: http://www.concrete5.org/community/forums/installation/5.6.0.1-upda...

I think it might have to do with outdated add-ons that needs to be updated as well before moving on to 5.6. See my response to a similar question here: http://www.concrete5.org/community/forums/installation/strange-data...
Eulalia replied on at Permalink Reply
Eulalia
Hey adajad

Updated from newspanel which opens on signin. Updated database of course.

Read your post to the other discussion. I will try an update on addons before going again- this will take me some time before I get back as I'm off to work soon and will get to it tonight.

Before I do, do you think mixing up elements within the site (using custom pages ie: width adjustments in plain yogurt theme, and using a customized dark chocolate theme in home page; or random assortments of image galleries) could contribute to these kind of issues?

Also, before I attempt update am going to have to study uploading database from hard drive as well as learning phpmyadmin for files and directories- all new territory. Anywhere I can go to get some info on this that I can understand?

Many thanks
adajad replied on at Permalink Reply
adajad
As long as you have your custom templates and themes outside the 'concrete' folder you should be good to go (unless you have helper/model/controller overrides).

As for phpMyAdmin you can probably find anything you need here (but if you can't, then Google is your friend): http://www.phpmyadmin.net/home_page/docs.php...
Eulalia replied on at Permalink Reply
Eulalia
Many thanks
Eulalia replied on at Permalink Reply
Eulalia
Back after a few days-!

I looked at phpmyadmin info and SQL in order to understand how to back up data, but either I'm dumb or need to spend more time in order to understand it.!!

So I took the plunge anyway, did addon updates , deleted cache and did the upgrade from 5.5.2.1 to 5.6.0.2. Same results. No site. Changed line in config/site.php back and deleted the 5.6.0.2 update in order to recover. BTW, any mods to themes were made and placed in root/themes, and none changed in concrete/themes.

Help please...!

Also- the code when I attempted the update-


Fatal error: Call to a member function setAttribute() on a non-object in /web/stephenscott.ca/httpdocs/updates/concrete5.6.0.2/concrete/core/models/collection.php on line 239
Eulalia replied on at Permalink Reply
Eulalia
I tried swapping the core using the 5.6.0 update. I moved and renamed json.php as suggested elsewhere. The site was reading the current update 5.5.2.1 in the updates folder, and the core concrete version is 5.5.1 which it is not using. So I removed the line in config/site.php- and got an error which read problem- view_newsflow.
agencecoteo replied on at Permalink Reply
agencecoteo
Had the same problem and do the second solution, it worked for me.