Wiki Home
Galleries
Contact us
Calendar
Toggle Wiki
Toggle Blogs
Toggle Forums
Toggle File Galleries
System error.

System error.

The following error message was returned:

Unknown column 'maxClicks' in 'where clause'

Database is not currently up to date! Visit Tiki Installer to resolve this issue. If you have shell (SSH) access, you can also use the following, on the command line, from the root of your Tiki installation: php installer/shell.php

The query was:

select `bannerId` from `tiki_banners` where `fri` = ? and `hourFrom`<=? and `hourTo`>=? and ( ((`useDates` = ?) and (`fromDate`<=? and `toDate`>=?)) or (`useDates` = ?) ) and (`impressions`<`maxImpressions` or `maxImpressions`=?) and (`clicks`<`maxClicks` or `maxClicks`=? or `maxClicks` is NULL) and `zone`=? order by RAND()

Values:

  1. y
  2. 0746
  3. 0746
  4. y
  5. 1280501162
  6. 1280501162
  7. n
  8. -1
  9. -1
  10. sponsors

The built query was likely:

select `bannerId` from `tiki_banners` where `fri` = 'y' and `hourFrom`<='0746' and `hourTo`>='0746' and ( ((`useDates` = 'y') and (`fromDate`<='1280501162' and `toDate`>='1280501162')) or (`useDates` = 'n') ) and (`impressions`<`maxImpressions` or `maxImpressions`='-1') and (`clicks`<`maxClicks` or `maxClicks`='-1' or `maxClicks` is NULL) and `zone`='sponsors' order by RAND()

Things to check:

  1. Is your database up and running?

  2. Is your database corrupt? Please see how to repair your database

  3. Are your database credentials (username, database name, etc) accurate?

  4. Did you complete the Tiki Installer?

Please see the documentation for more information.


TikiWiki CMS/Groupware