English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 12
TOPIC: Phoca SEF
#1618
Phoca SEF 15 Years, 4 Months ago Karma: 0
I quit using sh404sef due to virtuemart issues...back to joomla sef which means I need something to catch 404 and redirect them to the proper page...also good for transfering sites...anyhow I get this error when I try to use it on a slave site:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/meadows/domains/mvmdata.com/public_html/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/meadows/domains/mvmdata.com/public_html/libraries/joomla/database/database/mysql.php on line 344

I have 2 small prodution sites on this multi-site I'm hoping to get my big sites over there but need this first.
wtfbrb
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1622
Re:Phoca SEF 15 Years, 4 Months ago Karma: 54
It is not easy to identify which extension may cause these warnings.
The only way that I know to identify the origin consist in debugging the code and adding traces when it such conditions happen.

If you want that we debug the code on your server to tell you the extension that at the origin of this error, this is possible with our billable support that you can order at
www.jms2win.com/download?page=shop.produ...35&category_id=1
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1636
Re:Phoca SEF 15 Years, 4 Months ago Karma: 0
So is that a yes phoca is compatible but I may have other issues or is it a "What is Phoca SEF?"
wtfbrb
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1639
Re:Phoca SEF 15 Years, 4 Months ago Karma: 54
You say that Phoca is compatible and that you have other issues.
Which are the issues.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1692
Re:Phoca SEF 15 Years, 4 Months ago Karma: 0
I found the solution, the tables are not created for this extension on slave, so I used the following to create them just replaced jos_ with slave prefix and ran in phpmyadmin.

Code:

CREATE TABLE jos_phocasef_url 
( id int ( 11 ) NOT NULL auto_increment ,
cw int ( 11 ) NOT NULL default '0' ,   
cr int ( 11 ) NOT NULL default '0' ,   
new_url varchar ( 255 ) NOT NULL default '' , 
old_url varchar ( 255 ) NOT NULL default '' , 
date_url datetime NOT NULL default '0000-00-00 00:00:00' ,
published tinyint ( 1 ) NOT NULL default '0' , 
ordering int ( 11 ) NOT NULL default '0' , 
PRIMARY KEY (id) ) ;
CREATE TABLE jos_phocasef_ref (
id int ( 11 ) NOT NULL auto_increment , 
count_url int ( 11 ) NOT NULL default '0' ,
ref_url varchar ( 255 ) NOT NULL default '' ,
ref_to_url varchar ( 255 ) NOT NULL default '' ,
date_url datetime NOT NULL default '0000-00-00 00:00:00' ,
published tinyint ( 1 ) NOT NULL default '0' ,
ordering int ( 11 ) NOT NULL default '0' , 
PRIMARY KEY (id) ); 

wtfbrb
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1693
Re:Phoca SEF 15 Years, 4 Months ago Karma: 0
Also an fyi sh404sef is currently a dead project unless someone else takes it over...so joomla default sef and phocasef seems to me as the only way to go.
wtfbrb
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla