Oasis Technology Solutions

Attempt to specify article in Pretty Modules article leads to an error:

Warning: mysql_query () [function.mysql-query]: Access denied for user ' user_name ' ' localhost ' (using password: NO) in /home/ user_name/public_html/modules/mod_prettymodules15/mod_prettymodules15.php on line 95

Warning: mysql_query () [function.mysql-query]: A link to the server could not be established in /home/ user_name/public_html/modules/mod_prettymodules15/mod_prettymodules15.php on line 95

Warning: mysql_result (): supplied argument is not a valid MySQL result resource in /home/ user_name/public_html/modules/mod_prettymodules15/mod_prettymodules15.php on line 96

Warning: mysql_result (): supplied argument is not a valid MySQL result resource in /home/ user_name/public_html/modules/mod_prettymodules15/mod_prettymodules15.php on line 97

How I can solve this problem?

Thanks!

Access denied for user ' user_name ' ' localhost ' (using password: NO) in /home/ user_name/public_html/modules/mod_prettymodules15/mod_prettymodules15.phpThis seems to be a temporary server problem, as username and password are defined in Joomla! config and not in the module. The remaining three notices are because of this. Let me know
1) if you have other things running ok and only the module is giving this error.
2) if you have not given any database prefix like 'jos_' i.e if you have kept it null

ОК!

1. This error appears ONLY in Pretty Modules (I use a lot of components);
2. I have removed all old (not used) databases and have left only one (working), but without results.

I think that a problem in the following. I use component JoomFish which recommends to name MySqlDriver "mysqli". When I in server options specify database type "mysql" Pretty's Modules error message disappears, but there is message Joom Fish:
"No valid database connection Table ' user_name_jo152.jos_frsettings' does not exist SQL=SELECT * FROM jos_frsettings WHERE id = 1"

How to resolve this conflict?

I hope you are comforable hacking. Edit line 95 in /modules/mod_prettymodules15/mod_prettymodules15.php as below
1) Replace with or whatever the database prefix prefix is.
2) Replace with

First try both the hacks individually, and then togather.

ONLY if the above two things do not work, change to some real article id temporarily and revert if it works that way. If it works, try putting in double quotes.

I've not dwelved into the syntax difference between mysql and mysqli; just trying to make PM code similar to Joom Fish. Do revert

I tried to use all recommended ways in various combinations. However without result.

Even if the error is not present, the article in the module is NOT displayed.

I hope that in the subsequent versions this problem will be solved.
(I hope that it will occur till the moment of the termination of term of my subscription )

Bye!

While installing Joomla, did you select 'database type' as mysql or mysqli ? Also let me know the version; I'll try to run PM in your environment.

Even if the error is not present, the article in the module is NOT displayed.Let me know some details on the artiles settings of PM; if possible post a screen shot. Want to know if you are selecting to display just a single article (in this case you have to choose the article in the next field), how many articles, random articles, etc.

At installation Joomla the parameter ' database type ' was ' mysql ' (by default). The type has been changed after installation JoomFish. I make updating Joomla through cPanel (service Fantastico De Luxe). At the moment installed Joomla 1.5.15.
(Versions of other programs - look in attach)
In attach also there are screenshots of all PM parameters.

One more feature. If in ' Menu Assigment ' gets out ' Select Menu Item (s) from the List to Exclude/Home ' PM does not show (in not dependence on a module position).

In other cases the error (mysql), or simply border of the module without article (mysqli) is deduced. The static text specified in parametres PM is displayed without errors.

At a choice ' Article Type ' Random the error turns out:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/ran/public_html/modules/mod_prettymodules15/mod_prettymodules15.php on line 123

I wish successes!