Just purchased, finished upgrade and now MySql ERR

Welcome, Guest

TOPIC: Just purchased, finished upgrade and now MySql ERR

Just purchased, finished upgrade and now MySql ERR 14 years, 1 month ago #14013

jmayer OFFLINE Posts: 3	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, 1 month 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, 1 month ago #14034

jmayer OFFLINE Posts: 3	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, 1 month 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, 1 month ago #14076

jmayer
OFFLINE
Posts: 3

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, 1 month ago by jmayer.

The topic has been locked.

Re:Just purchased, finished upgrade and now MySql ERR 14 years, 1 month 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

ARTIO Forums

Support

TOPIC: Just purchased, finished upgrade and now MySql ERR