"No valid database connection" - a fix for 1.8.2

[Geraint]

Joomfish 1.8.2 went to press just before we identified the true cause of a problem some Virtuemart and Community Builder users have been reporting. You may therefore be seeing a message that says "No valid database connection".

A fix has been applied in Subversion (the development management system) and will be included in 1.8.3. In the meantime you can eliminate the message by replacing the file "administrator/components/com_joomfish/mldatabase.php" with the version attached to this message.

mldatabase.class.zip

Unzip and replace original file with this version

(6.27 KiB) Downloaded 2134 times

If you are still using version 1.8.1 of Joomfish (or earlier you should upgrade to 1.8.2 and apply this fix).

Geraint

p.s. Edited for correct version numbers

Technical Note

This problem generally arises from the use of INSERT ... SELECT (see mysql documentation) type queries. Joomfish is unable to translate the result of this type of query since no data is returned to PHP. If the translation of the offending queries is important then it needs to be split into 2 queries so that the SELECT can be translated before the INSERT takes place.

[claudiot]

The link "http://joomlacode.org/gf/download/frsrelease/6196/19217/JoomFish_1.8.1_to_1.8.2_patch.zip"
is not valid. Is the "mldatabase.class.zip" file your patch ?
Thanks. Claudio

[Geraint]

The link "http://joomlacode.org/gf/download/frsrelease/6196/19217/JoomFish_1.8.1_to_1.8.2_patch.zip"
is not valid. Is the "mldatabase.class.zip" file your patch ?

joomlacode.org is often inaccessible (server overload ) - just keep trying. After upgrading to 1.8.2 you should apply the fix in "mldatabase.class.zip".

[teddy]

Thanks for your update Geraint!
Does it contain the same modification you've clarified us here?
viewtopic.php?f=8&t=136&st=0&sk=t&sd=a&start=30#p1258
please, tell us, in order not to duplicate efforts (not so many, actually, just to know...)

[Geraint]

Thats the only difference the mldatabase.class.zip file incorporates

[claudiot]

The link "http://joomlacode.org/gf/download/frsrelease/6196/19217/JoomFish_1.8.1_to_1.8.2_patch.zip"
is not valid. Is the "mldatabase.class.zip" file your patch ?

joomlacode.org is often inaccessible (server overload ) - just keep trying. After upgrading to 1.8.2 you should apply the fix in "mldatabase.class.zip".

But how I can update from 1.8.1 to 1.8.2 if I can not donwload the patch ?
Claudio

[destanza]

I read about this topic on VirtueMart forum, one of the member still have problem with this patch.
"No valid database connection" is fixed, but notification mail is gone.

For full info, please read: http://forum.virtuemart.net/index.php?topic=35468.0

Thanks.

[lfcorreia]

Hi,

Had a problem that was to be solved by patch 1.8.1 to 1.8.2, followed the link and did not find the file, there must be something wrong with the link because I found the patch in here : http://joomlacode.org/gf/project/joomfish/frs/

After applying this mldatabase patch, the message "No valid database connection" disapeared, problem solved!

Thanx.

[tomislav_]

Hi,

I am using 1.8.2 but get the message "No valid database connection" when using facileForm component.

Any ideas? Thankful for any help/guidance I can get....

//t.

[Geraint]

did you read the first message in this topic?