Mysql Error report Subscriptions ???

[scalemotorcars]

An error was encountered during execution of the query:

SELECT COUNT(*) FROM cp_subscriptions WHERE isactive='yes'

The query returned with an errorcode of:

Table 'forum_scalemotorcars_com.cp_subscriptions' doesn't exist

If you need assistence or feel this is a 'bug'; please report it to
our support forums at:
http://www.photopost.com/members/forum/f66/index.html

Just got this in an email. Might have something to do with my earlier problems. Error creating thumbnail! Error code: 198

I don't have any subscriptions set on my photopost or classifieds. There is one on the forum but not activated.

Also didn't get the error until hours past making the changes.

[scalemotorcars]

Just got another

An error was encountered during execution of the query:

SELECT p.id,p.userid,p.start,p.end,s.name
FROM cp_paid_subscriptions p
LEFT JOIN cp_subscriptions s ON s.id=p.subid

The query returned with an errorcode of:

Table 'forum_scalemotorcars_com.cp_paid_subscriptions' doesn't exist

If you need assistence or feel this is a 'bug'; please report it to
our support forums at:
http://www.photopost.com/members/forum/f66/index.html

[scalemotorcars]

And another

An error was encountered during execution of the query:

SELECT id, name FROM cp_subscriptions ORDER BY id ASC

The query returned with an errorcode of:

Table 'forum_scalemotorcars_com.cp_subscriptions' doesn't exist

If you need assistence or feel this is a 'bug'; please report it to
our support forums at:
http://www.photopost.com/members/forum/f66/index.html

[scalemotorcars]

Going back over my error emails. 13 in all since updating to 3.0 Classifieds. I guess it could be PP but I really haven't made any changes to it for months.

[Chuck S]

I would suggest if you upgraded that you run your upgrade script. You issue tells me your tables do not exist.

[scalemotorcars]

Just ran it again. Check your PM for the link to the report.

[Chuck S]

Not a problem I sent a reply seems to be an issue with mysql maybe your running an older version.

[scalemotorcars]

4.0.27-standard Thought it was higher but Ive had server problems with my Host so they might be changing things around. You got mail.

[Chuck S]

Yeah version 4 and 5 both support setting a collation so I have no idea why your server is balking at that but thats the issue. I can remove the collation and see what happens.

[scalemotorcars]

You got mail. Thanks Chuck

[Chuck S]

yeah no idea why it did not work but I removed the collations and it worked

[scalemotorcars]

So Im good to go? That was quick

[Chuck S]

does everything appear to work?

[scalemotorcars]

PM'ed a test login and link Looks fine to me and I didn't see any error reports. The report I PM'ed last night should still be there.

[Chuck S]

If you have no errors then it was fixed. You only had an error because the tables did not exist and now they do

[scalemotorcars]

Thanks Chuck. Your the best...

[Chuck S]

enjoy your evening.

[scalemotorcars]

Guess what buddy, Got another last night.

An error was encountered during execution of the query:

SELECT id,bigimage,cat,userid,approved FROM cp_products WHERE cat=
AND userid=2 AND approved=1 ORDER BY date ASC

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'AND userid=2 AND approved=1 ORDER BY date ASC' at line 1

If you need assistence or feel this is a 'bug'; please report it to
our support forums at:
http://www.photopost.com/members/forum/f66/index.html

Ive got my host working on another issue right now but what do you think this is? I know it explains it but to me its another language.

[Chuck S]

IN showframe.php line 173 the query should be this using $cat not $dbcat

Content visible to verified customers only.

[scalemotorcars]

Thanks...