21 Posts
ralle
10 years ago
9
Topic
Hello Joomla-friends
After Update form Seblod Version 3.2.2 to 3.3.1 there is following error: 1054 Unknown column 'aliases' in 'field list' SQL=SELECT id, title, name, aliases, guest, guest_only_viewlevel, groups, viewlevels, configuration, options FROM jva6b_cck_core_sites WHERE published = 1
has anybody a solution for this bug? My Joomla Version is aktuell 3.3.2

thanks for our time to fix it
Get a Book for SEBLOD
21 Posts
ralle
10 years ago
1
Level 1
sorry your time ;-)
21 Posts
ralle
10 years ago
0
Level 2
After yesterday, I described my problem here in the forum, I got the message to go to the Sozialhub. There I wrote in Facebook directly my problem and the answer was that I should reinstall over the Extentionmanager Seblod. Next I should address myself to the forum here, I therefore now mache.Nach I have now installed this way Seblod again, I got the same problem described. What else can I do to be able to update to Seblod.?
10 years ago
0
Level 1
Hello ralle and welcome to the club of frustrated Joomla/Seblod users that are annoyed by strange behaviour and errors after a Joomla or Seblod update.
The good thing: you are not alone.
The bad thing: Getting real help for these issues happens very rarely.

Sorry for being sarcastic. But I spent endless hours trying to fix issues that occured after updates. Most of them are still a problem and I need to spent endless hours again to find a workaround.

Good luck!
Gerhard

PS: Funny idea, managing support through a facebook stream.
10 years ago
0
Level 1
Hi,

For this particular issue:
1054 Unknown column 'aliases' in 'field list' SQL=SELECT id, title, name, aliases, guest, guest_only_viewlevel, groups, viewlevels, configuration, options FROM jva6b_cck_core_sites WHERE published = 1


if you are able to.. please go to phpmyadmin > #__cck_core_sites, and add a new column after "name":
"aliases" which is a VARCHAR(512)

It should fix your issue. We've updated many websites on our side without experiencing this issue.
We'll have a look in order to replicate and fix it.

Regards,
Saba
21 Posts
ralle
10 years ago
4
Level 1
Thanks to all who have been thinking about a solution to my problemes! I have now found the error. In the table cck_core_sites in the column configuration was a been worth written with "ü" the hatte.seblod could not seblod taken not write the actual letter and broke the chain of mistakes. Of course I came only after Sabas tip behind.

Thanks SABA
21 Posts
ralle
10 years ago
3
Level 2
The joy was posted too fast :-( I get now when you call my menu links in the frontend the following error message.: 1054 Unknown column 'a.stylesheets' in 'field list' SQL=SELECT a.id, a.title, a.name, a.description, a.location, a.storage_location, b.app as folder_app, a.options_admin, a.options_site, a.options_content, a.options_intro, a.template_admin, a.template_site, a.template_content, a.template_intro, a.stylesheets FROM xxxx_cck_core_types AS a LEFT JOIN jva6b_cck_core_folders AS b ON b.id = a.folder WHERE a.name ="adresse" AND a.published = 1

Anyone who has this, an approach?

Thanks
21 Posts
ralle
10 years ago
2
Level 3
??? In the table cck_core_sites- column: aliases now i have found this : || ? Have anybody a Idea ? Thanks so lot

Raj
10 years ago
1
Level 4

Any reply on this issues? I find no much response after forum got upgraded to new one from seblod

21 Posts
ralle
10 years ago
0
Level 5

Hello raj,

A real solution I have not found for this error, so I had to install a completely new Joomla 3.xx. After that I clean installed the new Seblodversion and then laboriously by hand must Populate all contents again. Sorry otherwise I could not solve this error.
mfg ralle

Get a Book for SEBLOD