Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
ARTIO Forums
Support Forums
JoomSEF
Community Support
JoomSEF 3

NEW! 404 Redirect Handler for Artio JoomSEF
(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.
New Topic

TOPIC: NEW! 404 Redirect Handler for Artio JoomSEF

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1114

  • davidwhthomas
It sounds like an issue with your MySQL version and adding the table comment.

Before installing, open the com_404_redirect.zip archive file and click and edit the 404_redirect.xml file. Change this part (delete the comment='404 log' part):

 
<queries>
		<query>
		CREATE TABLE IF NOT EXISTS `#__404_log` (
		  `id` int(11) NOT NULL auto_increment,
		  `ip` varchar(100) default NULL,
		  `time` varchar(100) default NULL,
		  `referer_url` varchar(255) default NULL,
		  `requested_url` varchar(255) default NULL,
		  `redirected_url` varchar(255) default NULL,
		  `searchterm` varchar(255) default NULL,
		  `type` varchar(100) default NULL,
		  PRIMARY KEY  (`id`)
		) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='404 log';
		</query>
</queries>
 


to

<queries>
		<query>
		CREATE TABLE IF NOT EXISTS `#__404_log` (
		  `id` int(11) NOT NULL auto_increment,
		  `ip` varchar(100) default NULL,
		  `time` varchar(100) default NULL,
		  `referer_url` varchar(255) default NULL,
		  `requested_url` varchar(255) default NULL,
		  `redirected_url` varchar(255) default NULL,
		  `searchterm` varchar(255) default NULL,
		  `type` varchar(100) default NULL,
		  PRIMARY KEY  (`id`)
		) ENGINE=InnoDB DEFAULT CHARSET=latin1;
		</query>
</queries>


Then save it and try uploading and installing again.

Edit: I actually updated the main install file to take out that table comment. You could just download it one more time and try that file.

Let me know if that works.<br><br>Post edited by: davidwhthomas, at: 2006/12/21 00:15
The topic has been locked.

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1115

Hi David,

I removed the comment according to your instructions and I am still getting the same error.
I also downloaded and ran the installation again with the same results.

My website is hosted at 1and1 and the database used is MySQL 4.0.27

hmm, I have no idea what could be wrong.

Thank you.
The topic has been locked.

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1116

  • davidwhthomas
Hi Robert, thanks for letting me know. I'd like to get this solved in case other people have the same problem.

Try editing 404_redirect.xml file to this, for maximum compatibility:

 
&lt;queries&gt;
        &lt;query&gt;
        CREATE TABLE `#__404_log` (
          `id` int(11) NOT NULL auto_increment,
          `ip` varchar(100) default NULL,
          `time` varchar(100) default NULL,
          `referer_url` varchar(255) default NULL,
          `requested_url` varchar(255) default NULL,
          `redirected_url` varchar(255) default NULL,
          `searchterm` varchar(255) default NULL,
          `type` varchar(100) default NULL,
          PRIMARY KEY  (`id`)
        );
        &lt;/query&gt;
&lt;/queries&gt;
 



that may work!

EDIT:

Just checking the documentation for your mySQL version, you could try :

'CHARACTER SET = latin1'

instead of

'CHARSET = latin1'

that may work too.<br><br>Post edited by: davidwhthomas, at: 2006/12/22 02:06
The topic has been locked.

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1117

hurray...... :-)

the new code you provided for the xml file works.
I didn't try changing 'CHARSET = latin1' since the new query you posted works fine.
This is great.

Thank you so much for the component and for your help.

Robert
The topic has been locked.

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1119

David Thomas wrote:
Hi Sopra,

Szekely is right, the 404 redirect component is only activated when a page is not found.

It's purpose is to handle 404 errors gracefully, redirecting the user to the correct item or to a search.

If Artio is generating two different URLs for the same item, that is an issue with Artio SEF, not 404 redirect.

Secondly, did you install the RD Add PHP mambot / plugin ?

You posted your default 404 page and the mambot tag shouldn't show up if that mambot is installed.

You can get it here :
www.run-digital.com/download/mambots.html

Add PHP is required for 404 Redirect to function.

regards,

DT


Thank you David and Szekely,

Yes, the 404 component is working great! just that I have that issue with duplicate content on different urls, I will try to find an workaround for this one (if you are thinking on anyone, pls let me know), and now I have like 3 options: a javascript menu, not having two menu items linking to the same component or changing somehow in the &quot;View/Edit SEF Urls&quot; from JoomSef backend.

Sorry, I thought that the 404 component will fix this also.

Thanks a lot,
Sopra
The topic has been locked.

Re:NEW! 404 Redirect Handler for Artio JoomSEF 17 years, 11 months ago #1126

  • davidwhthomas
Hi peoples,

If anyone else has some ideas etc.. that they would like to see included in the next version of 404 redirect, please let me know.

So, if you have a problem with particular types of 404 errors that are not currently solved by the component, please post a sample URL and how you would like the error fixed. I'll see what I can do.

Hope you're all having a good holiday!

cheers,

David T
The topic has been locked.
New Topic
ARTIO Forums
Support Forums
JoomSEF
Community Support
JoomSEF 3
User Login Empty
Create an account Forgot your password?
Copyright © 2024 ARTIO