Calendar


Upcoming Events (Within next 31 days):
There are no upcoming events

Upcoming Birthdays (Within next 31 days):
Congratulations to: JohnnyTheOne (29 on Sun 19th Sep)
nGAGE™ (35 on Thu 30th Sep)
musta (35 on Wed 29th Sep)
Bingle (40 on Fri 17th Sep)
Donations

All information and modifications on this site are open source and free, but any donations are gratefully received. They also provide the fuel (beer) that keeps me motivated!

Thanks, Stu

Online Users

In total there are 0 users online :: 0 registered, 0 hidden and 0 guests.

Most users ever online was 208 on Mon Jul 12, 2010 8:05 am

Users browsing this forum: No registered users and 0 guests based on users active over the past 60 minutes

New Install SQL Fail

Quick guides for some common general tasks

Moderators: Dev Team, SGP Team, MODerators

New Install SQL Fail

PostAuthor: Marc on Sat Jul 03, 2010 3:50 am

So after spending a good few hours getting all the files modified, and all the new ones uploaded and such, I went into my phpBB3 forum's ACP (I'm not using the portal) and activated the calendar (the first version, since it needs to be installed before the updates can be).

Now, almost every aspect of the calendar works; all the admin panel pages, permissions, etc.

But not the actual calendar (calendar.php, to be exact). Here's the error I get:

SQL ERROR [ mysqli ]

Table 'clouts_main.CALENDAR_REPEATS_TABLE' doesn't exist [1146]

SQL

SELECT * FROM CALENDAR_REPEATS_TABLE WHERE (event_start_time BETWEEN '1277956800' AND '1280635199') OR (event_end_time BETWEEN '1277956800' AND '1280635199') ORDER BY event_start_time ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/functions_calendar.php
LINE: 852
CALL: dbal_mysqli->sql_query()

FILE: calendar.php
LINE: 1086
CALL: get_events()

FILE: calendar.php
LINE: 368
CALL: build_calendar_panel()




Any help is appreciated!
Marc
 
Posts: 1
Joined: Fri Jul 02, 2010 7:01 pm

Re: New Install SQL Fail

PostAuthor: KND on Mon Jul 19, 2010 12:28 pm

read viewtopic.php?f=2&t=201#p958 again ;)

grab the SQL code under 7. (click "spoiler").

if your phpbb installation has modified table names (e.g. myinstall_phpbb_topics instead of phpbb_topics):
copy/paste code from the spoiler to notepad or similar. edit all (5, i think) table names to match your installation.

use phpMyAdmin or similar to run the SQL code on your database

enjoy
KND
 
Posts: 1
Joined: Mon Jul 19, 2010 10:26 am


Return to How To...

Who is online

Users browsing this forum: No registered users and 1 guest

cron