Event Calendar RSVP

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 10:28 am

OK everything is done...sorry it took me a while I will now verify its working as it should.
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby battye » Sat Feb 06, 2010 10:31 am

Are you able to post a screenshot of the index page (with an alert appearing)? I'd like to make sure it is appearing as it should :)

Thanks
CricketMX.com.. home of bat's, rat's and other farmyard animals...
My articles: view all articles by battye

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
User avatar
battye
Site Admin
Site Admin
 
Posts: 14253
Joined: Sun Jan 11, 2004 8:26 am
Location: Victoria Falls, Zimbabwe

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 10:51 am

hmmm...
I am getting this when I set an alert. What could I have done wrong?

Code: Select all
General Error
SQL ERROR [ mysqli ]

Incorrect integer value: 'Today' for column 'alert_text' at row 1 [1366]

SQL

INSERT INTO phpbb_alerts (user_id, alert_text, alert_time, alert_day, alert_day_before, alert_week, alert_week_leading, alert_global) VALUES ('53', 'Today', 1265353200, 1, 0, 0, 0, 0)

BACKTRACE

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

FILE: includes/ucp/ucp_alerts.php
LINE: 100
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_alerts->main()

FILE: ucp.php
LINE: 325
CALL: p_master->load_active()
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby battye » Sat Feb 06, 2010 10:57 am

If you look in phpMyAdmin, is the column alert_text set to be of type VARCHAR(255) ?
CricketMX.com.. home of bat's, rat's and other farmyard animals...
My articles: view all articles by battye

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
User avatar
battye
Site Admin
Site Admin
 
Posts: 14253
Joined: Sun Jan 11, 2004 8:26 am
Location: Victoria Falls, Zimbabwe

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:01 am

Whoops sorry i got it.
`alert_text` VARCHAR( 255 ) NOT NULL ,

I had it set to int...I'm drowsy
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:11 am

Hmmm...It keeps telling me this date even though I put in today's date:
Your alert for 04 Feb 2010, 23:00 has been submitted to the database. You will be notified this many days before each event:
On the day
Day before
Attachments
Mod.pdf
PDF
(409.43 KiB) Downloaded 134 times
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby battye » Sat Feb 06, 2010 11:13 am

Does anything appear on your index page? (purge the cache from the ACP before you look)

If not, can you go into the phpbb_alerts table in the database and post the number you see in the "alert_time" field.
CricketMX.com.. home of bat's, rat's and other farmyard animals...
My articles: view all articles by battye

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
User avatar
battye
Site Admin
Site Admin
 
Posts: 14253
Joined: Sun Jan 11, 2004 8:26 am
Location: Victoria Falls, Zimbabwe

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:23 am

I get this on the index page
Code: Select all
[phpBB Debug] PHP Notice: in file /index.php on line 135: Division by zero
[phpBB Debug] PHP Notice: in file /index.php on line 136: Division by zero
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4202: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3494)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4204: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3494)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4205: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3494)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4206: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3494)


The DB time is:
Code: Select all
1265266800
Attachments
Mod.pdf
(713.74 KiB) Downloaded 144 times
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby battye » Sat Feb 06, 2010 11:27 am

That certainly is very strange. I just want to confirm two things..

1) what does the forum clock say on the index page? is that showing the correct time or is that also slow?
2) what timezone have you selected in your profile?

To get rid of those other errors, in index.php FIND;

Code: Select all
$rsvp_yes_percent = number_format(($rsvp_yes / $rsvp_total), 0);
      $rsvp_no_percent = number_format(($rsvp_no / $rsvp_total), 0);


REPLACE WITH

Code: Select all
$rsvp_yes_percent = ($rsvp_total < 1) ? 0 : number_format(($rsvp_yes / $rsvp_total), 0);
      $rsvp_no_percent = ($rsvp_total < 1) ? 0 : number_format(($rsvp_no / $rsvp_total), 0);
CricketMX.com.. home of bat's, rat's and other farmyard animals...
My articles: view all articles by battye

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
User avatar
battye
Site Admin
Site Admin
 
Posts: 14253
Joined: Sun Jan 11, 2004 8:26 am
Location: Victoria Falls, Zimbabwe

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:29 am

Index page time is: It is currently 06 Feb 2010, 03:22

Time Zone: UTC -8 Pacific Standard Time
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:34 am

Other errors gone.

Thank you for all of this help.
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby havocwreaker » Sat Feb 06, 2010 11:52 am

I'm going to have to go to bed now. My eyes are closing. I'll check this in the morning to see if there is anything I can troubleshoot. Thank you for staying around to assist me.
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby havocwreaker » Tue Feb 09, 2010 2:01 am

Any thoughts why this could be happening?
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

Re: Event Calendar RSVP

Postby battye » Tue Feb 09, 2010 4:52 am

If you enter the exact same set of times here at CMX (UCP -> Alerts) as you do on your site, what results do you get?

Make sure the timezone you are in is the same, for consistency.
CricketMX.com.. home of bat's, rat's and other farmyard animals...
My articles: view all articles by battye

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
User avatar
battye
Site Admin
Site Admin
 
Posts: 14253
Joined: Sun Jan 11, 2004 8:26 am
Location: Victoria Falls, Zimbabwe

Re: Event Calendar RSVP

Postby havocwreaker » Tue Feb 09, 2010 6:01 am

Wow,

I enter today's date and I get:
Your alert for Sat Feb 06, 2010 10:00 pm has been submitted to the database. You will be notified this many days before each event:
On the day
Day before

Could it be something with the Pacific time setting? It's weird that this site does the same as mine. Both go back 2 days.
havocwreaker
Frequent Poster
Frequent Poster
 
Posts: 39
Joined: Tue Feb 02, 2010 5:04 am

PreviousNext

Return to Web Design

Who is online

Users browsing this forum: No registered users and 1 guest

cron