Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] Error 1054: Something with CB subs

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
8 years 7 months ago - 8 years 7 months ago #279485 by timstohr
Hey guys,

I have installed the new CB subs and am getting this error (may actually not have anything to do with the new CB subs since I have changed the settings). This happens when I go on anyones profile in the user manager as well as when I go onto the payment center.

Unknown column 'b.time_updated' in 'where clause' SQL=SELECT b.id FROM munich_cbsubs_payment_baskets b WHERE b.payment_status = 'NotInitiated' AND b.payment_method IS NULL AND b.user_id = 2062 AND b.time_updated < DATE_SUB( UTC_TIMESTAMP(), INTERVAL 3 HOUR) LIMIT 0, 100

Any solutions?
Last edit: 8 years 7 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
8 years 7 months ago - 8 years 7 months ago #279487 by timstohr
Replied by timstohr on topic Error 1054: Something with CB subs
Solved. Due to my complicated multi-sites arrangement, the MySQL and the PHP code had gone out of sync for the slave sites. I have now brought them back to sync by installing the new CB subs on the slave MySQL databases.

I am slowly getting better at this stuff...
Last edit: 8 years 7 months ago by timstohr.
The following user(s) said Thank You: beat, krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum