Easy Module Changer Released

Read more

Easy Class Suffixes Released

Read more

Pretty Modules 1.3 Released

Read more

OASIS Technology Solutions Support Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottom
TOPIC: Article error
#141
Article error 1 Month, 2 Weeks ago  
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!
 
Logged Logged
 
Last Edit: 2010/01/24 15:00 By prtrans@gmail.com.
  The administrator has disabled public write access.
#142
admin
Admin
Posts: 80
graph
User Online Now Click here to see the profile of this user
Re:Article error 1 Month, 2 Weeks ago  
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
 
Logged Logged
  The administrator has disabled public write access.
#143
Re:Article error 1 Month, 2 Weeks ago  
ОК!

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?
 
Logged Logged
  The administrator has disabled public write access.
#144
admin
Admin
Posts: 80
graph
User Online Now Click here to see the profile of this user
Re:Article error 1 Month, 2 Weeks ago  
I hope you are comforable hacking. Edit line 95 in /modules/mod_prettymodules15/mod_prettymodules15.php as below
1) Replace
Code:

" . $db->getPrefix() . "
with
Code:

jos_
or whatever the database prefix prefix is.
2) Replace
Code:

SELECT title, introtext, alias FROM
with
Code:

SELECT * FROM


First try both the hacks individually, and then togather.

ONLY if the above two things do not work, change
Code:

$artic
to some real article id temporarily and revert if it works that way. If it works, try putting
Code:

$artic
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
 
Logged Logged
  The administrator has disabled public write access.
#145
Re:Article error 1 Month, 2 Weeks ago  
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!
 
Logged Logged
  The administrator has disabled public write access.
#146
admin
Admin
Posts: 80
graph
User Online Now Click here to see the profile of this user
Re:Article error 1 Month, 1 Week ago  
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.
 
Logged Logged
  The administrator has disabled public write access.
#147
Re:Article error 1 Month, 1 Week ago  
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!
File Attachment:
File Name: PM_parameters.zip
File Size: 180954
 
Logged Logged
 
Last Edit: 2010/01/28 05:49 By prtrans@gmail.com.
  The administrator has disabled public write access.
Go to top