Menu Content

Support

> Forums, FAQs & Paid Support
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? 16 years, 6 months ago #10977

  • chaos
  • OFFLINE
  • Posts: 4
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)
The topic has been locked.

Re:Could not save the SEF URL to database? 16 years, 6 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?
The topic has been locked.

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

  • dajo
  • OFFLINE
  • Posts: 5064
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
The topic has been locked.

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

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

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

  • dajo
  • OFFLINE
  • Posts: 5064
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
The topic has been locked.

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

  • lyochum1
  • OFFLINE
  • Posts: 1
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: 16 years, 4 months ago by lyochum1.
The topic has been locked.
  • Page:
  • 1
User Login Empty