Menu Content

Support

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

Could not save the SEF URL to database?
(1 viewing) (1) Guest
Support forum for users using free edition of JoomSEF 3 (Joomla 1.5 compatible). These forums are mainly for mutual help between users.

Please note that due to our capacity limitations, we do not monitor these forums regularly.
  • Page:
  • 1

TOPIC: Could not save the SEF URL to database?

Could not save the SEF URL to database? 14 years, 10 months ago #10977

Getting this as soon as i activate Artio, any ideas anyone?

JoomSEF Error - Could not save the SEF URL to database: Unknown column 'priority' in 'field list' SQL=INSERT INTO `jos_sefurls` (`sefurl`, `origurl`, `priority`, `Itemid`, `trace`) VALUES ('rss', 'index.php?option=com_content&format=feed&type=rss&view=frontpage', '90', '187', NULL)

Re:Could not save the SEF URL to database? 14 years, 9 months ago #11054

  • Jon
  • OFFLINE
  • Posts: 7
I'm getting this error, too.

JoomSEF Error - Could not save the SEF URL to database: Unknown column 'priority' in 'field list'

Any suggestions, anyone, please?

Re:Could not save the SEF URL to database? 14 years, 9 months ago #11067

  • dajo
  • OFFLINE
  • Posts: 5069
Hello,

It seems the priority field was not added correctly to the table structure during some of your upgrade. Please, run the following SQL on your Joomla database, that should fix it:

ALTER TABLE `jos_sefurls` ADD COLUMN `priority` INT(11) NOT NULL DEFAULT '0' AFTER `dateadd`


(replace the jos_ prefix with your own if needed)

Best regards,
ARTIO Support Team
ARTIO Support Team

Re:Could not save the SEF URL to database? 14 years, 9 months ago #11068

  • Jon
  • OFFLINE
  • Posts: 7
I don't know how to do that... can you advise me please?

Re:Could not save the SEF URL to database? 14 years, 9 months ago #11073

  • dajo
  • OFFLINE
  • Posts: 5069
Your web host probably provided you with access to your database using phpMyAdmin or some similar tool. In case of phpMyAdmin: log in, select your database, click the SQL tab, put the SQL I've posted in there and click the Run button. In other tools the process should be similar.

Best regards,
ARTIO Support Team
ARTIO Support Team

Re:Could not save the SEF URL to database? 14 years, 8 months ago #11961

Seems like this should be a very similar problem...
I am receiiving:

JoomSEF Error - Could not save the SEF URL to database: Unknown column 'sm_indexed' in 'field list' SQL=INSERT INTO `jos_sefurls` (`sefurl`, `origurl`, `priority`, `Itemid`, `trace`, `sm_indexed`, `sm_date`, `sm_frequency`, `sm_priority`) VALUES ('rss', 'index.php?option=com_content&format=feed&type=rss&view=frontpage', '90', '1', NULL, '0', '2010-04-26', 'weekly', '0.5')

Can you help?


NEVERMIND - It is a very similar situation... I added the proper fields and it all works out OK....
Last Edit: 14 years, 8 months ago by lyochum1.
  • Page:
  • 1
User Login Empty