Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Big Problem Upgrading to 3.3.0
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Big Problem Upgrading to 3.3.0

Big Problem Upgrading to 3.3.0 14 years, 11 months ago #6703

  • Sigi
  • OFFLINE
  • Posts: 12
After upgrading to 3.3.0 i have this error

No valid database connection Unknown column 'sefurl' in 'where clause' SQL=SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'de/restaurant/restaurant.html') OR (`sefurl` = 'de/restaurant/restaurant.html/')) AND (`origurl` != '') LIMIT 1
No valid database connection Unknown column 'sefurl' in 'where clause' SQL=SELECT * FROM `jos_sefurls` WHERE `sefurl` = 'de/restaurant/restaurant.html'

Error: headers already sent in intercept.jdatabasemysql.php on line 77.
Stopped at line 731 in joomsef.php

and this error on the index.php

No valid database connection Unknown column 'sefurl' in 'where clause' SQL=SELECT * FROM jos_sefurls WHERE sefurl = '' OR sefurl = 'index.php' LIMIT 1
No valid database connection Unknown column 'sefurl' in 'field list' SQL=SELECT `sefurl` FROM `jos_sefurls` WHERE `origurl` = 'index.php?option=com_xmap〈=de&sitemap=1'
No valid database connection Unknown column 'sefurl' in 'field list' SQL=SELECT `sefurl` FROM `jos_sefurls` WHERE `origurl` = 'index.php?option=com_xmap〈=de&sitemap=1'
No valid database connection Unknown column 'origurl' in 'field list' SQL=SELECT `origurl`, `Itemid` FROM `jos_sefurls` WHERE `sefurl` = 'de/xmap.html' AND `origurl` != ''
No valid database connection Unknown column 'sefurl' in 'where clause' SQL=SELECT `id` FROM `jos_sefurls` WHERE `sefurl` = 'de/xmap.html' AND `origurl` = ''


please help me.
I have a backup installed on my testserver
88.116.182.170/waldschenke/
Ihave installed on the testserver and the real server php5

on the Homepage i have turned off artio, now joomla works.

Thanks

Sigi
The topic has been locked.

Re:Big Problem Upgrading to 3.3.0 14 years, 11 months ago #6704

  • jaku
Hello,

this seems like the DB upgrade did not get through correctly.
I recommend a manual fix.

Edit the database - table jos_sefurls (earlier jos_redirection).
Rename columns:
oldurl -> sefurl
newurl -> origurl

Then it should work fine.
Last Edit: 14 years, 11 months ago by .
The topic has been locked.

Re:Big Problem Upgrading to 3.3.0 14 years, 11 months ago #6712

  • Sigi
  • OFFLINE
  • Posts: 12
Thanks, now it works fine.
The topic has been locked.

Re:Big Problem Upgrading to 3.3.0 14 years, 11 months ago #6726

hi,

i had the same problem ... the fix runs fine.

Thx
The topic has been locked.

Re:Big Problem Upgrading to 3.3.0 14 years, 11 months ago #6997

same problem and i managed to do what you asked. seems to be working fine now

For a retail shop keeper I'm sure learning a lot about altering databases.
The topic has been locked.
  • Page:
  • 1
User Login Empty