Forums / Cotonti / Support / mysql error ?

The Stig
#1 2010-11-15 03:56
I get this warning in the error log

PHP Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/blah/public_html/system/database.mysql.php on line 25

And below is the part of the code the above is referring to.

if (!defined('SED_CODE')) { die('Wrong URL.'); }

function sed_sql_affectedrows()
{ return (mysql_affected_rows()); }

/* ------------------ */

function sed_sql_close($id='')
{ return(mysql_close($id)); }

/* ------------------ */

function sed_sql_connect($host, $user, $pass, $db)
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
$select = @mysql_select_db($dbName, $db, $connection) or sed_diefatal('Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
return($connection);
}

Thanks in advance ...Stig
pieter
#2 2010-11-15 06:29
Is this on a fresh install or on the upgraded version from seditio?
... can we help you ...
The Stig
#3 2010-11-15 08:38
Hi Pieter

Its to do with urlkillers usergal...everything works apart from the slideshow and that is the only error i get. This is on a sed site which one of the sites i'm looking to upgrade to cotonti but i've read that it does the same thing with that. Theres nothing wrong with the site as i have also tried it on another new installation on diferent webspace and get exactly the same result.

I'd love to get it working as it looks great...alas no more support from killer and all the links to his site for usergal are broken !

c'mon killer please bring it back !
pieter
#4 2010-11-15 15:29
Check this usergal.
http://www.cotonti.com/forums.php?m=posts&q=5299&d=30

It is not the latest version, but all works.
... can we help you ...
The Stig
#5 2010-11-15 18:20
everything is working though...just the slideshow not working
pieter
#6 2010-11-15 19:28
I though there was a solution for this at neocrome.net
By taking some files from the previous version.

Maybe you can PM urlkiller.
He is here at Cotonti.
He is working with EZ for a new PFS-system.
... can we help you ...
The Stig
#7 2010-11-15 22:32
its everytime i press the slideshow button the error comes up in the usergal error log

Added 31 minutes later:

ok...found 1 more thing wrong...
when i upload images to a folder they don't appear in usergal anymore...but they did at one time ?

Dit bericht is bewerkt door The Stig (2010-11-15 23:04, 14 jaren ago)
urlkiller
#8 2010-11-16 03:05
@The Stig

Iam not 100% sure anymore but maybe check out the file that generated the slideshow.
i guess i made some bad steps in the development like adding a own DB connection... ;(

i would give that a shot first.

and someone ported a version to cot...

Added 9 minutes later:

*PLEASE BE AWARE THIS ARN'T COTONTI PLUGINS*
AND tada only for you: http://bbm.li/!1971E6
a file history BUt be aware that i dont give any real support for these files!!!
i can help here a bit but i wont fixing bugs...
URL shortener: <a href="http://bbm.li/!7AD5C7">http://bbm.li/!7AD5C7</a>

Dit bericht is bewerkt door urlkiller (2010-11-17 05:40, 14 jaren ago)
The Stig
#9 2010-11-16 03:17
Thankyou very much killer ...i'll give it a go :)