MySQL warning

[caro84g]

Hi,

I'm testing Phoca SEF on my localhost. I get this warning when I select 'redirect site' or 'referring sites'.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Temp\USBwebserver\root\libraries\joomla\database\database\mysql.php on line 344

If I purposely go to a 404 page, then it isn't stored in my backend.

I guess it's some problem with my database.

System info:
PHP gebouwd op: Windows NT ----- 5.1 build 2600
Database versie: 5.0.24a-community-nt
Database collatie: utf8_general_ci
PHP versie: 5.2.4
Webserver: Apache/2.2.0 (Win32) PHP/5.2.4
Webserver naar PHP interface: apache2handler
Joomla! versie: Joomla! 1.5.9
Phoca SEF 1.0.0beta

Carolien

[Jan]

Hi, were tables created? see them e.g. in phpMyAdmin

#__phocasef_ref
#__phocasef_url

Jan

[caro84g]

No.

I installed it a second time on the same webserver and no tables created again.

Regards, Carolien

[Jan]

try to enable debug mode while installing, maybe you get some error message (for the error message, there needs to be added an "exit;" command into line: 95 in controllers/phocainstall.php (in ZIP file)

because if there is no exit; it comes to redirect and possible message output by debug mode will be lost

Jan

[caro84g]

Hi Jan,

This is weird: I deinstalled and then reinstalled again and it worked! It's all working now. I installed it on my webserver and it's working too now.

I don't know what the problem was, but it's working right now.

Regards, Carolien

[bellatrix]

I've got the same warning and now understand why.
When you first install Phoca SEF then you see instructions to alter error.php file.
But doing so one forgets to press Install button below and goes directly to the component in the Joomla menu.
In fact, the component is not installed yet but it looks like everything is done.
To my mind, slight modification is needed to prevent missing this installation step, Jan.
Thank you for your excellent extension!

[Jan]

Hi, the installation cannot be automated. There is a solution to add e.g. system plugin, but the idea of this component is to not use the system plugin which is in fact a listener and slow down the system. So if you will alter the 404 then you need not to use system plugin anymore and your site will be not slow down by this component. It only runs if the 404 is comming, not while standard displaying. So, yes, the altering of 404 is a little bit complicated but then it save you the system resources.

Jan