vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Invalid Default Value (https://vborg.vbsupport.ru/showthread.php?t=91422)

dsboyce8624 07-01-2005 12:36 AM
Invalid Default Value
 
Okay, with newer version we are not allowed to use DEFAULT '0' like we were and this is causing problems in some older, but still popular hacks. Shoutbox, and Member Album to name a couple.

If we are will to to make the corrections we need to know what changes to make.

In Shoutbox there is this code:

Code:
$query['new'][] = 'CREATE TABLE '.TABLE_PREFIX.'shoutbox_posts (
                                  `shoutid` BIGINT (255) UNSIGNED DEFAULT \'0\' AUTO_INCREMENT,
                                  `text` TEXT,
                                  `userid` BIGINT (255) UNSIGNED DEFAULT \'0\',
                                  `username` VARCHAR (255) DEFAULT \'0\',
                                  `ip` VARCHAR (25) DEFAULT \'0\',
                                  `time` BIGINT (20) UNSIGNED DEFAULT \'0\',
                                  `edittime` BIGINT (20) UNSIGNED DEFAULT \'0\',
                                  `edituser` VARCHAR (255) DEFAULT \'0\',
                                  `deleted` TINYINT(1) UNSIGNED DEFAULT \'0\',
                                  PRIMARY KEY(`shoutid`))';

$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'usergroup
                                  ADD `shoutboxpermissions` INT(10) UNSIGNED DEFAULT \'0\' NOT NULL,
                                  ADD `shouthierarchy` TINYINT(5) UNSIGNED DEFAULT \'0\' NOT NULL,
                                  ADD `shoutmaxdaily` TINYINT(5)    UNSIGNED DEFAULT \'0\' NOT NULL';

$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'user
                                  ADD `shouts` BIGINT(10) UNSIGNED DEFAULT \'0\' NOT NULL,
                                  ADD`shoutbanned` TINYINT(1) UNSIGNED DEFAULT \'0\' NOT NULL';
And I know it breaks there, because mine broke there.

There doesn't seem to be any support for this, at least not enough to make it worth mentioning. So, can somebody tell me how to modify these queries so they work?

Thanks a bunch.

Marco van Herwaarden 07-01-2005 07:30 AM
New version of what? vB, MySQL?

And what doesn't work, you get an error message?

And please post questions about a hack in the thread about that hack.

dsboyce8624 07-01-2005 03:05 PM
New versions of MySQL.

Yes there is an error, Invalid Default Value '0'

This is not about the hack, this is about correcting queries.

Marco van Herwaarden 07-01-2005 03:06 PM
And what is the exact error you are getting?

Marco van Herwaarden 07-01-2005 03:08 PM
Ahh just checked those queries now. There is 1 error in them:
[sql] `shoutid` BIGINT (255) UNSIGNED DEFAULT \'0\' AUTO_INCREMENT,
[/sql]
You can not have a default value for an auto increment field. Change that line to:
[sql] `shoutid` BIGINT (255) UNSIGNED AUTO_INCREMENT,
[/sql]

Marco van Herwaarden 07-01-2005 03:12 PM
Actually if you would have posted this in the Shoutbox thread, i think someone would have been able to help you much faster, since the answer to your question is already there: https://vborg.vbsupport.ru/showthrea...ent#post639730

dsboyce8624 07-02-2005 02:02 AM
Beleive it or not, I read the whole damned thing, and missed it.

I guess it was just too much.

Thanks.


All times are GMT. The time now is 09:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00948 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete