Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me

Just purchased, finished upgrade and now MySql ERR
(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: Just purchased, finished upgrade and now MySql ERR

Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14013

hi-lite (dot) com/us please help

at the top of the page, mysql error

No valid database connection Table 'hilite_us.us_sefaliases' doesn't exist SQL=SELECT `a`.`vars`, `u`.`sefurl` FROM `us_sefaliases` AS `a` INNER JOIN `us_sefurls` AS `u` ON `u`.`id` = `a`.`url` WHERE `a`.`alias` = ''

Whats GOING ON!!
The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14023

  • dajo
  • OFFLINE
  • Posts: 5069
Hello,

The _sefaliases table wasn't created properly. What steps have you taken to upgrade your JoomSEF? What version of JoomSEF did you have installed before the upgrade?

Best regards,
ARTIO Support Team
ARTIO Support Team
The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14034

I dont recall what version it was before the upgrade, It would have been a couple minor releases back though.

I used the online upgrade option within the artio component
The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14046

  • dajo
  • OFFLINE
  • Posts: 5069
It's strange that it upgraded files even when the table was not created correctly.. Please, use some MySQL manager (for example phpMyAdmin) and run the following SQL on your database:
CREATE TABLE IF NOT EXISTS `us_sefaliases` (
`id` int(11) NOT NULL auto_increment,
`alias` varchar(255) NOT NULL DEFAULT '',
`vars` text NOT NULL,
`url` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `alias` (`alias`)
) TYPE=MyISAM;


Best regards,
ARTIO Support Team
ARTIO Support Team
The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14076

Well, among other things, a huge bunch of issues.

I ended up going back and restoring from a backup the database and full site files..

I am using jms2win Multi sites. I have many different locations/sites all using the same joomla install.
I have had major issues with the hosti (Network Solutions) pretty poor, not as poor as godaddy but pretty close.

I finally got everything updated, and now, all links give an error.
I am using firefox, so its a fire fox error

"Firefox has detected that the server is redirecting the request for this address in a way that will never complete."

and no page never displays..

if I disable artio the pages load fine with the standard joomla sef turned on still

interesting thing is the other sites/locations still work.. what could be different. some configuration issue. I am sure
Last Edit: 14 years, 3 months ago by jmayer.
The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 3 months ago #14083

  • dajo
  • OFFLINE
  • Posts: 5069
It seems that JoomSEF's upgrade process is not compatible with the JMS Multisite.

For the redirection problem, try disabling one or more of the following settings in JoomSEF's configuration:
www and non-www domain handling (Basic tab)
Redirect nonSEF URLs to SEF (Advanced tab)
Parse Joomla SEO links (Advanced tab)
Fix index.php links (Advanced tab)

If it doesn't help, please, post the link to your site where I can see this problem.

Best regards,
ARTIO Support Team
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
Přihlášení uživatele Prázdný