Countdown Block

[Dragonsys]

ok guys, i cannot get this to work, i edited all the files, uploaded the included files, ran the db querie and i get this

Error

SQL query:

CREATE TABLE phpbb_countdown(
img_left varchar( 255 ) NOT NULL default '',
img_right varchar( 255 ) NOT NULL default '',
title varchar( 100 ) NOT NULL default '',
description varchar( 100 ) NOT NULL default '',
event_text varchar( 200 ) NOT NULL default '',
event_stop int( 11 ) NOT NULL default '',
enable_index tinyint( 1 ) default '0',
enable_portal tinyint( 1 ) default '0',
full_display tinyint( 1 ) default '1'
) TYPE = MYISAM ;

MySQL said: Documentation
#1067 - Invalid default value for 'event_stop'

and it does not create the phpbb_countdown table.

so when i go to my forum i get

General Error

Could not get countdown settings

and no template at all, help please <img>

The DB problem is because the field is being set to NOT NULL but you are entering a NULL default value.

[ayasha]

ok, so what do i enter? i kinda understand what you are saying, but as to what to change, i have no clue.

[Dragonsys]

You can try this...

Code: Select all

CREATE TABLE phpbb_countdown( img_left varchar( 255 ) default '', img_right varchar( 255 ) default '', title varchar( 100 ) default '', description varchar( 100 ) default '', event_text varchar( 200 ) default '', event_stop int( 11 ) default '', enable_index tinyint( 1 ) default '0', enable_portal tinyint( 1 ) default '0', full_display tinyint( 1 ) default '1' ) TYPE = MYISAM ;

[ayasha]

that did not work Dragonsys <img>

[Dragonsys]

that did not work Dragonsys <img>

same error? It worked on my site....

[ayasha]

i got this

Error

SQL query:

CREATE TABLE phpbb_countdown(
img_left varchar( 255 ) default '',
img_right varchar( 255 ) default '',
title varchar( 100 ) default '',
description varchar( 100 ) default '',
event_text varchar( 200 ) default '',
event_stop int( 11 ) default '',
enable_index tinyint( 1 ) default '0',
enable_portal tinyint( 1 ) default '0',
full_display tinyint( 1 ) default '1'
) TYPE = MYISAM ;

MySQL said: Documentation
#1067 - Invalid default value for 'event_stop'

[Dragonsys]

ok, strange. I just tried both SQL commands, and they both work fine for me...

are you trying to enter this via ACP phpmyadmin or straight phpmyadmin or a straight SQL call?

[Dragonsys]

try this... copy the below code into a db_update.php file and upload it to the root of your forum. The browse to it ( http://www.graphicsplayhouse.com/psp/db_update.php )

Let me know if that works.

Code: Select all

<?php/***************************************************************************  *                               db_update.php  *                            -------------------  *  *   copyright            ]http://sourceforge.net/projects/dbgenerator[/url]  *   Website              : [url=http://freakingbooty.no-ip.com/]http://freakingbooty.no-ip.com/[/url] & [url=http://www.rapiddr3am.net]http://www.rapiddr3am.net[/url]  *  ***************************************************************************/  /***************************************************************************  *  *   This program is free software; you can redistribute it and/or modify  *   it under the terms of the GNU General Public License as published by  *   the Free Software Foundation; either version 2 of the License, or  *   (at your option) any later version.  *  ***************************************************************************/  define('IN_PHPBB', true);$phpbb_root_path = './';include($phpbb_root_path . 'extension.inc');include($phpbb_root_path . 'common.'.$phpEx);  //// Start session management//$userdata = session_pagestart($user_ip, PAGE_INDEX);init_userprefs($userdata);//// End session management//    if( !$userdata['session_logged_in'] ){     $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';     header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));     exit;}  if( $userdata['user_level'] != ADMIN ){     message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');}    $page_title = 'Updating the database';include($phpbb_root_path . 'includes/page_header.'.$phpEx);  echo '<table>';echo '<tr><th>Updating the database</th></tr><tr><td><span><ul>';    $sql = array();$sql[] = "CREATE TABLE " . $table_prefix . "countdown( img_left varchar( 255 ) NOT NULL default '', img_right varchar( 255 ) NOT NULL default '', title varchar( 100 ) NOT NULL default '', description varchar( 100 ) NOT NULL default '', event_text varchar( 200 ) NOT NULL default '', event_stop int( 11 ) NOT NULL default '', enable_index tinyint( 1 ) default '0', enable_portal tinyint( 1 ) default '0', full_display tinyint( 1 ) default '1' ) TYPE = MYISAM";  for( $i = 0; $i <count>sql_query ($sql[$i]) )     {         $error = $db->sql_error();           echo '<li>' . $sql[$i] . '<br> +++ <font><b>Error:</b></font> ' . $error['message'] . '</li><br>';     }     else     {         echo '<li>' . $sql[$i] . '<br> +++ <font><b>Successfull</b></font></li><br>';     }}    echo '</ul></span></td></tr><tr><td> </td></tr>';  echo '<tr><th>End</th></tr><tr><td><span>Installation is now finished. Please be sure to delete this file now.<br>If you have run into any errors, please visit the <a>phpBBSupport.co.uk</a> and ask someone for help.</span></td></tr>';echo '<tr><td><span><a>Have a nice day</a></span></td></table>';  include($phpbb_root_path . 'includes/page_tail.'.$phpEx);  ?>

[ayasha]

ok, i am working in my xampp, just so you know it is not a live forum

run SQL query/queries on database in the xampp phpMyadmin.

is that what you want to know?

[Dragonsys]

ok, i am working in my xampp, just so you know it is not a live forum

run SQL query/queries on database in the xampp phpMyadmin.

is that what you want to know?

maybe it's somethign in the xampp mySQL. I've never played with xampp before.
Try the db_update file above though.

[ayasha]

ok, i am going back to the beginning, and recheck everything, will let you know what i find out if anything. <img>

[ayasha]

i have tried everything i could think of, i cannot get this query to create a table <img>

[Teelk]

I can't find any instance of where an integer's default is emtpy. This leads me to believe that an integer must have a value. Although, Dragonsys seems to be getting it to work, so I may just be blowing smoke here. Every instance I've seen sets the default value to 0, so it should be safe.

Then again, it could be a MySQL5 issue.

Code: Select all

CREATE TABLE phpbb_countdown(img_left varchar( 255 ) default '',img_right varchar( 255 ) default '',title varchar( 100 ) default '',description varchar( 100 ) default '',event_text varchar( 200 ) default '',event_stop int( 11 ) default '0',enable_index tinyint( 1 ) default '0',enable_portal tinyint( 1 ) default '0',full_display tinyint( 1 ) default '1') TYPE = MYISAM ;

[Ebony]

Cleo honey.... I will get Methos over here he installed it fine on the realm... I don't understand it???

it installed fine on the realmy.

[Ebony]

Hello again friends,

I would like to know if you know how to insert the Minutes and Seconds in the said countdown field (pls refer to the attached, in red color)

[flash=,]http://i19.photobucket.com/albums/b164/doswald/PHPBB/countdown.jpg[/flash:2acerpte]

Thanks, hope to hear again.

Regards,
Doswald

don't quote me on this.. but I think that is automatically set to run by your forum clock. I haven't actually played with that bit yet I am sorry...