31 Posts
Catastrophix
10 years ago
15
Topic
Hello to the SEBLOD Community,

I wonder if anyone is having the same trouble upgrading to SEBLOD 3.2 as I am?

  1. I upgrade Joomla 3.1.5 to 3.2.1 and then upgrade Seblod 3.1.5 to 3.2 with the following error after the installation: "Duplicate column name 'path' SQL=ALTER TABLE nairn_cck_core_folders ADD path VARCHAR( 1024 ) NOT NULL AFTER parent_id;"
  2. I get the following error when I try open any of my Form/Content types: "Oops! Try to close the page & re-open it properly."
  3. My front page looks like this: http://energy.org.za/threetwo/
Any guidance you can offer will be greatly appreciated.
Thanks!


Get a VIP membership
143 Posts
pretobrazza
10 years ago
1
Level 1
Hi Catastrophix,

On 'Xmasday I upgraded Joomla after having done a backup with akeeba from J3.1.1 to J3.2.1 from within the Joomla administrator. I got the serious and recurring warning that I had to switch Magic quotes OFF. Being 'Xmas day my provider couldn't turn it off right away. Despite the warning, I upgraded Seblod from 3.15 to 3.2.

And indeed, I got a similar warning too about a duplicate column name or so but everything worked fine. The following day my provider switched Magic quotes and output buffering OFF. Just to make sure I reinstalled Seblod 3.2 and I do not seem to have any problems.

If this can help you,
Bernard
31 Posts
Catastrophix
10 years ago
0
Level 2
Hi Bernard

Both of those settings are OFF in my config (PHP 5.4.4-14), so unfortunately that is not the problem.

But thanks for your input!

Regards,
Steve
31 Posts
Catastrophix
10 years ago
0
Level 1
I get the same error when upgrading to 3.2.1. - 1060 Duplicate column name 'path' SQL=ALTER TABLE nairn_cck_core_folders ADD path VARCHAR( 1024 ) NOT NULL AFTER parent_id;
572 Posts
_jrmo
10 years ago
1
Level 1
Go in to the extension manager, go to "database" (on the left) and click "fix"

Does that help?
31 Posts
Catastrophix
10 years ago
0
Level 2
Sadly not James. Thanks for your input.

I've decided to revert to a more familiar CCK as the upgrade process has become a bit of an ordeal which I can't quite afford right now. But I'll definitely keep abreast of SEBLOD developments as I certainly do get glimpses of its immense power. Thanks also for your contributions which I found most useful in beginning to understand the SEBLOD paradigm.

Cheers,
Stephen
10 years ago
1
Level 1
Hi Stephen,

"Duplicate column name 'path' SQL=ALTER TABLE nairn_cck_core_folders ADD path VARCHAR( 1024 ) NOT NULL AFTER parent_id;"
We haven't encountered this issue so far.. but we'll do more tests.
Can you please let us know what was the initial version of SEBLOD on your site? Was it 3.1.5? or a previous one?

Thanks & Regards,
Saba.
31 Posts
Catastrophix
10 years ago
0
Level 2
Hi Saba

It was 3.1.5

I'd be happy to recreate the original environment for you with an admin login if it helps in your testing.

Cheers
10 years ago
3
Level 1
Thanks for starting the topic.

I have similar problems with the upgrade from 3.1 tot 3.3 ....

' SQL=ALTER TABLE choir_cck_core_folders ADD path VARCHAR( 1024 ) NOT NULL AFTER parent_id;'

after that I try install it again and it works but my main list is corrupted

Also had the pagination problem.
10 years ago
2
Level 2
Maybe interesting to know,

sometimes I also get "SQL=ALTER TABLE `choir_cck_core_type_field` ADD `restriction` VARCHAR( 512 ) NOT NULL COMMENT 'admin,site,intro,content' AFTER `access`;"

Either way I can't upgrade without crashing the current functions. Thanks in advance!
31 Posts
Catastrophix
10 years ago
1
Level 3
Oh dear. I hope I don't experience the same when I try to upgrade.

My problem above was never solved despite being able to recreate it and I spent most of my December holidays having to build my entire site on the new version of SEBLOD in order to continue with the Joomla upgrade path. Not something I can ever afford to repeat.

I'll let you know if I get the same error when I upgrade (possibly later today). I'll be going from 3.3.0 to 3.3.2.

Cheers
31 Posts
Catastrophix
10 years ago
0
Level 4
I'm fortunate to report a successful upgrade from SEB 3.3.0 to 3.3.2 despite the troubles I experienced in earlier upgrades on the same infrastructure as outlined above
10 years ago
3
Level 1
Afterwards I get:

SQL=SELECT a.id, a.title, a.name, a.alias, a.description, a.content, a.location, a.storage_location, a.stylesheets, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item FROM choir_cck_core_searchs AS a LEFT JOIN choir_cck_core_folders AS b ON b.id = a.folder WHERE a.name ="try_again" AND a.published = 1

and

SQL=SELECT DISTINCT a.id, a.title, a.name, a.folder, a.type, a.label, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.link, c.link_options, c.live, c.live_options, c.live_value, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.stage, c.access, c.restriction, c.restriction_options, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM choir_cck_core_fields AS a LEFT JOIN choir_cck_core_type_field AS c ON c.fieldid = a.id WHERE c.typeid = 62 AND c.client = "admin" ORDER BY c.ordering ASC

any idea which column I might miss?
10 years ago
2
Level 2
With all the upgrading back-and-forth I get

"Warning: call_user_func_array() expects parameter 1 to be a valid callback, class 'plgCCK_Fieldradio' not found in /----------/domains/-----/public_html/libraries/cms/cck/cck.php on line 31" in the original 3.1.5.

Also when I upgrade I seem to be missing the columns 'markup' and 'stylesheets'.

Sorry for being such a nuisance btw!
10 years ago
1
Level 3
- After destroying the 'restriction' column manually the upgraded succeeded eventually.

- After adding the missing columns manually the form became back to life.

- The last error on cck.php on line 31 had to do with the fields: div_end, div_in between and div_start

Almost done with fixing the pagination (which apparently works properly on a new search form)!
10 years ago
0
Level 4
The pagination error is caused by setting the search form as 'Home' in the menu manager! (for me at least)

Clearly a bug!
Get a VIP membership