Menu Content

Support

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

JoomSEF Error - Could not save the SEF URL to data
(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
  • 2

TOPIC: JoomSEF Error - Could not save the SEF URL to data

JoomSEF Error - Could not save the SEF URL to data 7 years, 6 months ago #34434

When I click on Jevents page I get below error, I just recently updated to a paid version of joomsef3 and this seems to have occured since then......? I also downloaded the jevents extension but still doesn't work

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Re: JoomSEF Error - Could not save the SEF URL to data 7 years, 6 months ago #34510

  • dajo
  • OFFLINE
  • Posts: 5070
Hi,
Please enable the "Debug System" option in Joomla's Global Configuration on the System tab. Then the error message should also display the exact SQL query that caused it. Please post the SQL.
ARTIO Support Team

Re: JoomSEF Error - Could not save the SEF URL to data 7 years, 6 months ago #34663

Hi
I get this up the top

Notice: Undefined property: stdClass::$host in /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/components/com_sef/joomsef.php on line 510

and this below

500 - JDatabaseMySQL::query: 1054 - Unknown column 'host' in 'field list' SQL=INSERT INTO `jos_sefurls` (`sefurl`, `origurl`, `priority`, `Itemid`, `trace`, `sm_indexed`, `sm_date`, `sm_frequency`, `sm_priority`, `locked`, `host`) VALUES ('icalrepeat-detail/10487/2012/11/18/acupuncture-damien-10am-4pm/352793dc06844b4c7a26d70350ff0560/57-58-59-60-61-62-68-66', 'index.php?option=com_jevents&catids=57|58|59|60|61|62|68|66&day=18&evid=10487&month=11&task=icalrepeat.detail&title=acupuncture-damien-10am-4pm&uid=352793dc06844b4c7a26d70350ff0560&year=2012', '90', '55', NULL, '0', '2012-11-28', 'weekly', '0.5', '0', '')

Re: JoomSEF Error - Could not save the SEF URL to data 7 years, 6 months ago #34685

  • dajo
  • OFFLINE
  • Posts: 5070
It seems that there was some problem during update of your JoomSEF sometime in the past and the database wasn't updated correctly.
Use phpMyAdmin or similar tool to run the following SQL query on your Joomla database:
ALTER TABLE `jos_sefurls` ADD COLUMN `host` VARCHAR(255) NOT NULL DEFAULT '';
ARTIO Support Team

Re: JoomSEF Error - Could not save the SEF URL to data 7 years, 5 months ago #34754

Many thanks have run the sql guess I now need to wait for the pages to be crawled again?

Re: JoomSEF Error - Could not save the SEF URL to data 7 years, 5 months ago #34757

Still not working i am getting below as well

# Function Location

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

1 JSite->dispatch()

index.php:68 2 JComponentHelper->renderComponent() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/includes/application.php:124

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

3 require_once()

libraries/joomla/application/component/helper.php:162

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

4 JController->execute()

components/com_jevents/jevents.php:200

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

5 MonthController->calendar()

libraries/joomla/application/component/controller.php:236 6 JEventsAbstractView->display() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/components/com_jevents/controllers/month.php:70

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

7 JView->display()

administrator/components/com_jevents/views/abstract/abstract.php:49

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

8 JView->loadTemplate()

libraries/joomla/application/component/view.php:192

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

9 include()

libraries/joomla/application/component/view.php:564

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

10JView->loadTemplate()

components/com_jevents/views/default/month/tmpl/calendar.php:7

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

11include()

libraries/joomla/application/component/view.php:564 12 EventCalendarCell_default->calendarCell() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/components/com_jevents/views/default/month/tmpl/calendar_body.php:68

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

13JRoute->_()

components/com_jevents/views/default/month/tmpl/calendar_cell.php:350

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

14JRouterJoomsef->build()

libraries/joomla/methods.php:54

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

15JoomSEF->build()

components/com_sef/sef.router.php:165 16 JoomSEF->_storeLocation() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/components/com_sef/joomsef.php:499

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

17JoomSEF->_checkRow()

components/com_sef/joomsef.php:2579 18 JoomSEF->_saveNewURL() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/components/com_sef/joomsef.php:2733

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

19 JDatabaseMySQL->query()

components/com_sef/joomsef.php:2845

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

20JError->raiseError()

libraries/joomla/database/database/mysql.php:231

/clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/

21JError->raise()

libraries/joomla/error/error.php:171 22JException->__construct() /clientdata/zeus-dynamic-1/g/p/gponebleymedicalcentre.com.au/www/libraries/
  • Page:
  • 1
  • 2
User Login Empty