1. Commentics Forum
  2. General
  3. Bugs
This is the community forum. For a developer response use the Client Area.
Follow us on Facebook, Twitter and YouTube!

Like (thumb) gives error
mariank
Member
**
Posts: 48
Threads: 11
Joined: Dec 2013
#1

31-Dec-2013, 01:30 PM
when I click on the thumbs up/down I receive this error

Quote:Sorry, there is a database problem.

Please check back shortly. Thanks.

It never worked
Find
Reply
Steven
Administrator
*****
Posts: 2,872
Threads: 59
Joined: Jun 2010
#2

31-Dec-2013, 05:48 PM
Can you open /comments/includes/db/connect.php

There should be 3 instances of this line:

cmtx_db_error_general();

Above each instance, add a unique echo, like this:

echo '1';
cmtx_db_error_general();

..

echo '2';
cmtx_db_error_general();

etc

Then try to vote again and see which number displays.

You can then remove the echo lines.
Have you completed the interview?
Find
Reply
Steven
Administrator
*****
Posts: 2,872
Threads: 59
Joined: Jun 2010
#3

31-Dec-2013, 05:50 PM
(31-Dec-2013, 01:30 PM)mariank Wrote:  It never worked

It hasn't ever worked, you mean?
Have you completed the interview?
Find
Reply
mariank
Member
**
Posts: 48
Threads: 11
Joined: Dec 2013
#4

31-Dec-2013, 06:24 PM
yes - I mean it hasn't ever worked - I said that cause the message they gave made it sound a temporary problem so I was saying it wasn't a temporary problem - it never worked

I'll try with the echo lines and see what we find
Find
Reply
mariank
Member
**
Posts: 48
Threads: 11
Joined: Dec 2013
#5

01-Jan-2014, 10:43 AM
(31-Dec-2013, 05:48 PM)Steven Wrote:  Can you open /comments/includes/db/connect.php

There should be 3 instances of this line:

cmtx_db_error_general();

Above each instance, add a unique echo, like this:

echo '1';
cmtx_db_error_general();

..

echo '2';
cmtx_db_error_general();

etc

Then try to vote again and see which number displays.

You can then remove the echo lines.

Sorry I disappeared - Hostgator must have been having a wild New Year's party - I couldn't get my site,FTP,control panel

OK - I put in those lines and they're always 1 - so the problem is at the first one
Find
Reply
Steven
Administrator
*****
Posts: 2,872
Threads: 59
Joined: Jun 2010
#6

01-Jan-2014, 07:53 PM
Can you replace this:

PHP Code:
<?php 

@$cmtx_connection = mysql_connect ($cmtx_mysql_host, $cmtx_mysql_username, $cmtx_mysql_password);

With this:

PHP Code:
<?php 

$cmtx_connection = mysql_connect ($cmtx_mysql_host, $cmtx_mysql_username, $cmtx_mysql_password);

echo mysql_errno($cmtx_connection) . ": " . mysql_error($cmtx_connection);

(Note that I removed the @ on the first line)
Have you completed the interview?
Find
Reply
mariank
Member
**
Posts: 48
Threads: 11
Joined: Dec 2013
#7

02-Jan-2014, 06:55 AM
This is the error I get for a thumbs up (in green)
Quote:Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'michalk'@'localhost' (using password: NO) in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 39

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40
: 1
Commentics

Sorry, there is a database problem.

Please check back shortly. Thanks.

Dislike0

This is the warning for a thumbs down (in red)
Quote:Randy says...
Another City Mini lover
PermalinkPermalink
FlagFlag
Like0
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'michalk'@'localhost' (using password: NO) in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 39

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40
: 1
Commentics

Sorry, there is a database problem.

Please check back shortly. Thanks.

If I choose flag I get this message in blue
Quote:Sherry says...
I'm a BoB revolution lover
PermalinkPermalink

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'michalk'@'localhost' (using password: NO) in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 39

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home2/michalk/public_html/childchat.org/comments/includes/db/connect.php on line 40
: 1
Commentics

Sorry, there is a database problem.

Please check back shortly. Thanks.
Find
Reply
Steven
Administrator
*****
Posts: 2,872
Threads: 59
Joined: Jun 2010
#8

02-Jan-2014, 09:22 PM
It looks like the vote.php file and the flag.php file are having trouble reading at least one, if not all, of the connection variables in the file details.php.

So in connect.php replace this line ..

PHP Code:
<?php 

require_once 'details.php'; //load database details

with your connection variables from details.php.

The code in connect.php should now look something like this:

PHP Code:
<?php 

@$cmtx_db_orig = mysql_query("SELECT DATABASE();");

@$cmtx_db_orig = mysql_result($cmtx_db_orig, 0);



$cmtx_mysql_database = '';                // The name of the database you created

$cmtx_mysql_username = '';                 // Your MySQL username

$cmtx_mysql_password = '';                 // Your MySQL password

$cmtx_mysql_host = 'localhost';            // Usually 'localhost'. Can also be an IP address.

$cmtx_mysql_port = '';                    // In most cases leave blank.

$cmtx_mysql_table_prefix = '';            // In most cases leave blank.



require_once 'failure.php'; //load failure messages

.. except your connection variables will obviously be filled in.

Before you do that, you might first want to try setting normal file permissions for details.php.

Another thing to check is to make sure you have granted your MySQL user full permissions.
Have you completed the interview?
Find
Reply
mariank
Member
**
Posts: 48
Threads: 11
Joined: Dec 2013
#9

05-Jan-2014, 03:43 PM
That's it! Putting the connection variables right in the connect file worked perfectly

thanks
Find
Reply
« Next Oldest | Next Newest »


Possibly Related Threads…
Thread / Author Replies Views Last Post
Error: Could not load email new_version!
tashi
Last Post by tashi
28-Jan-2020, 10:05 AM
3rd party filer.js still calls .size() and throws an error
ddraber
Last Post by Zey
24-Apr-2019, 07:08 AM
w3 reports ERROR Bad Value
jennifer
Last Post by Steven
14-Jul-2018, 05:35 PM
Brief flash of page when error box is shown
Apod42
Last Post by Steven
26-Jul-2016, 05:50 PM
Sorry but 1 error was found
Christopher
Last Post by Christopher
11-Jun-2016, 12:16 PM
Unexpected Token Error
franck
Last Post by Steven
03-Mar-2016, 08:12 PM
Strange 404 Error When Hovering Over Admin Menu
Methyus
Last Post by Methyus
01-Nov-2015, 10:50 AM
alignment error when smilies are disabled
stevenvh
Last Post by Steven
24-Jan-2013, 06:25 PM
Minor error in help text.
stariocek
Last Post by Steven
09-Jul-2012, 01:18 PM
frm.cmtx_terms is undefined javascript error
jonoweb
Last Post by Steven
27-Jun-2012, 03:12 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. Commentics Forum
  2. General
  3. Bugs