Menu Content

Support

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

Error on enable - db table prefix #__ ?
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Error on enable - db table prefix #__ ?

Error on enable - db table prefix #__ ? 16 years, 3 months ago #4301

Hi!

When I enable Artio 3.1.0 (I have Joomla 1.5.3) my front page goes dead! All I see is plain text:

string(176) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('front/spread-the-word.html', 'index.php?option=com_content&catid=40&id=98&view=article', '170')" string(129) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('my-profile.html', 'index.php?option=com_comprofiler', '157')" string(153) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('form.html', 'index.php?option=com_content&id=109&view=article', '173')" string(149) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('qsummary.html', 'index.php?option=com_jqsummary&layout=form1&view=forms', '174')" string(172) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('top-panel/form.html', 'index.php?option=com_content&catid=41&id=106&view=article', '165')" string(127) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('user-forum.html', 'index.php?option=com_kunena', '156')" string(154) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('faqs/index.php', 'index.php?option=com_content&id=3&layout=blog&view=section', '171')" string(151) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES ('about.html', 'index.php?option=com_content&id=115&view=article', '172')"

Since I have the "jos_" db table prefix I guess the problem is that Artio tries to access the db with the wrong prefix "#__". But where do I change this? (In global configuration I have the correct "jos_" prefix...) What to do??

/Mikael
Last Edit: 16 years, 3 months ago by Mikeymike.

Re:Error on enable - db table prefix #__ ? 16 years, 3 months ago #4305

  • dajo
  • OFFLINE
  • Posts: 5069
Hello,

the #__ is not a problem, it is a placeholder which Joomla automatically converts to correct prefix. For some reason, these queries were not executed properly, although they seem to be all right. Please check the jos_redirection table in your database if it was successfuly created during JoomSEF installation and if you have rights to access it.

Best regards,
ARTIO Support Team
ARTIO Support Team

Re:Error on enable - db table prefix #__ ? 16 years, 3 months ago #4317

I un- and re-installed the component... Yes I have the jos_redirection table. But it's empty... And I have the same problem... string(152) "INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES (.... What to do?

I should have all the SEO settings (global configuration) Search Engine Friendly URLs, Use Apache mod_rewrite and Add suffix to URLs set to yes, right, caus that's what I have...

I also have the Joomlatwork SEF patch for Joomla release 1.5 Stable (www.joomlaatwork.com) installed, and hope it's not going to mess up stuff... I also use Joomfish...

Thanks for your help!

/Mikael

Re:Error on enable - db table prefix #__ ? 16 years, 3 months ago #4319

  • dajo
  • OFFLINE
  • Posts: 5069
Yes, your configuration is correct, and other components should not cause this problem. I think there's something wrong with your MySQL database settings. Please, check if the Joomla DB user has privilege to insert new rows in jos_redirection table. Or try executing one of the INSERT queries manually using phpMyAdmin or your favorite software, replacing the #__redirection with jos_redirection, to see if there is a problem with the query or with the database.

Best regards,
ARTIO Support Team
ARTIO Support Team

Re:Error on enable - db table prefix #__ ? 16 years, 3 months ago #4323

It seems like there is a problem with the query.. The db doesn't like Itemid. It should be just id!

"INSERT INTO `#__redirection` (`oldurl`, `newurl`, `Itemid`) VALUES (....

So what can I do?

Mikael

Re:Error on enable - db table prefix #__ ? 16 years, 3 months ago #4324

  • dajo
  • OFFLINE
  • Posts: 5069
Please, post the exact error your DB returns. It should not be just id, the Itemid field has its meaning, id field should be auto incrementing. Please, check the structure of your jos_redirection table - if the Itemid column is missing, there is probably some problem with creating the table during installation.

Best regards,
ARTIO Support Team
ARTIO Support Team
  • Page:
  • 1
  • 2
User Login Empty