'votes' column missing from comments table

Royalridge · September 25th, 2007, 04:38 PM

Sorry if this has been reported, but I couldn't find a forum thread for it.

Enabled "contest" voting for a category and when attempting to access the category I get the following error:

Quote:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT photo FROM pp_comments WHERE cat=502 AND userid=3903 AND votes=1

Result: Unknown column 'votes' in 'where clause'

Database handle: Resource id #20

Looking at the install.php file shows that it doesn't even attempt to create a "votes" column.

Can you please advise on the field spec for this missing field.

Michael P · September 25th, 2007, 07:06 PM

Actually, it does on line 686:

Code:

Content visible to verified customers only.

the upgrade.php line reads:

Code:

Content visible to verified customers only.

Are you sure you arent working off an outdated BETA?

Chuck S · September 25th, 2007, 07:44 PM

My suggestion is to redownload the build upload the files and run upgrade.php just to ensure as Michael pointed out maybe you where working off a beta. This issue was addressed in one of our beta versions of the software and fixed in beta 2 or beta 3 If I remember correctly.

Royalridge · September 26th, 2007, 03:32 AM

Quote:

Originally Posted by Michael P

Actually, it does on line 686:

Code:

Content visible to verified customers only.

the upgrade.php line reads:

Code:

Content visible to verified customers only.

Are you sure you arent working off an outdated BETA?

The select statement that's giving the error, as written, will be looking for the votes column in the comments table, the line 686 you refer to adds a votes column to the photos table, so either the query is wrong or the comments table is not being set up correctly.

No, I am not working off an outdated BETA, I am a new (unhappy) customer and the code was downloaded "fresh" from the members area.

Royalridge · September 26th, 2007, 03:37 AM

Quote:

Originally Posted by Chuck S

My suggestion is to redownload the build upload the files and run upgrade.php just to ensure as Michael pointed out maybe you where working off a beta. This issue was addressed in one of our beta versions of the software and fixed in beta 2 or beta 3 If I remember correctly.

I ran the upgrade.php script on my fresh, clean 3.6 installation, performed the 5.61/5.62 to 6.0 upgrade, ignoring the SQL errors and the column was added to the comments table.

As previously stated above, this was a clean install from a new customer download, not a upgrade from any beta.

Royalridge · September 26th, 2007, 05:49 AM

Guys, this is getting beyond a joke. In showgallery.php lines 235 and 240 refer to the column as "votes" but the actual column name according to the code in misc.php refers to it as "vote"

I bought this script primarily to run a contest, not as a PHP debugging exercise.

Michael P · September 26th, 2007, 08:19 AM

I posted about the photos table, not the comments table. You are correct, in showgallery.php and in misc.php we incorrectly address the "vote" column for the comments table where the "vote" field is suppose to be.

This release is days old; some less used functions may shake out over the first few days of a new release as all the new features get used.

Royalridge · September 26th, 2007, 08:48 AM

Quote:

Originally Posted by Michael P

This release is days old; some less used functions may shake out over the first few days of a new release as all the new features get used.

This is what beta testing and release candidate testing is for.

The situation now is that I've spent over $100 on a product and given the number of bugs I've encountered and reported I have zero confidence in deploying this on my live website.

Michael P · September 26th, 2007, 09:30 AM

Apparently these particular issues did not get caught during the BETA and RC testing. As I said, with new releases follow-on dot releases are not uncommon in this industry when even aggressive testing does not catch every issue.