PhotoPost Community - Mysql Error report Subscriptions ???

Page 1 of 2

Show 40 post(s) from this thread on one page

PhotoPost Community (http://www.photopost.com/forum/)

- Classifieds Installation & Upgrades (http://www.photopost.com/forum/classifieds-installation-upgrades/)

- - Mysql Error report Subscriptions ??? (http://www.photopost.com/forum/classifieds-installation-upgrades/135951-mysql-error-report-subscriptions.html)

scalemotorcars

March 24th, 2008 06:17 PM

Mysql Error report Subscriptions ???

Quote:

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. http://www.photopost.com/forum/classifieds-bug-reports/135947-error-creating-thumbnail-error-code-198-a.html

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. :confused:

scalemotorcars

March 24th, 2008 06:19 PM

Just got another

Quote:

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

March 24th, 2008 06:27 PM

And another

Quote:

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

March 24th, 2008 06:45 PM

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

March 24th, 2008 07:09 PM

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

scalemotorcars

March 24th, 2008 07:29 PM

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

Chuck S

March 24th, 2008 11:06 PM

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

scalemotorcars

March 25th, 2008 08:32 AM

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

March 25th, 2008 10:00 AM

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

March 25th, 2008 01:32 PM

You got mail. Thanks Chuck

Chuck S

March 25th, 2008 01:55 PM

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

scalemotorcars

March 25th, 2008 01:57 PM

So Im good to go? That was quick

Chuck S

March 25th, 2008 02:03 PM

does everything appear to work?

scalemotorcars

March 25th, 2008 02:10 PM

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

March 25th, 2008 03:11 PM

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

March 25th, 2008 04:31 PM

Thanks Chuck. Your the best... :D

Chuck S

March 25th, 2008 08:25 PM

enjoy your evening.

scalemotorcars

March 26th, 2008 05:21 PM

Guess what buddy, Got another last night.

Quote:

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. :o

Chuck S

March 26th, 2008 06:57 PM

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

Code:

Content visible to verified customers only.

scalemotorcars

March 27th, 2008 01:55 PM

Thanks... :)

All times are GMT -5. The time now is 02:38 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97