Threaded Mode | Linear Mode

TomNook08 · 03-13-2009 03:55 AM

Nope didn't work I'm sorry if I'm being annoying

Splappy · 03-13-2009 04:07 AM

It worked for me...
Find this:

PHP Code:

$catalog_admin = array(
        'gid'            => 'NULL',
        'name'            => 'catalogadmin',
        'title'            => 'Catalog Admin',
        'description'    => 'Settings For The Catalog System.',
        'disporder'        => $rows+1,
        'isdefault'        => 'no',
    );

    $db->insert_query('settinggroups', $catalog_admin);
    $gid = $db->insert_id();

    $catalog_setting_1 = array(
        'sid'            => 'NULL',
        'name'            => 'enablecatalog',
        'title'            => 'Enable Catalog System?',
        'description'    => 'If set to off, no one will get a catalog',
        'optionscode'    => 'onoff',
        'value'            => 'on',
        'disporder'        => 1,
        'gid'            => intval($gid),
    );

    $catalog_setting_2 = array(
        'sid'            => 'NULL',
        'name'            => 'showwhichgames',
        'title'            => 'Show Which Game',
        'description'    => 'Set to 1 to show only ACGC items, 2 to show only ACWW items, 3 to show ACCF/LGTTC items, or 0 for all 3 games',
        'optionscode'    => 'text',
        'value'            => '0',
        'disporder'        => 2,
        'gid'            => intval($gid),
    );
    $catalog_setting_3 = array(

        'sid'            => 'NULL',
        'name'            => 'adminitems',
        'title'            => 'Admin Remove Items?',
        'description'    => 'Do you want admins to be able to remove items?',
        'optionscode'    => 'onoff',
        'value'            => 'off',
        'disporder'        => 3,
        'gid'            => intval($gid),
    ); 

And replace it with this:

PHP Code:

$catalog_admin = array(
        'gid'            => NULL,
        'name'            => 'catalogadmin',
        'title'            => 'Catalog Admin',
        'description'    => 'Settings For The Catalog System.',
        'disporder'        => $rows+1,
        'isdefault'        => 'no',
    );

    $db->insert_query('settinggroups', $catalog_admin);
    $gid = $db->insert_id();

    $catalog_setting_1 = array(
        'sid'            => NULL,
        'name'            => 'enablecatalog',
        'title'            => 'Enable Catalog System?',
        'description'    => 'If set to off, no one will get a catalog',
        'optionscode'    => 'onoff',
        'value'            => 'on',
        'disporder'        => 1,
        'gid'            => intval($gid),
    );

    $catalog_setting_2 = array(
        'sid'            => NULL,
        'name'            => 'showwhichgames',
        'title'            => 'Show Which Game',
        'description'    => 'Set to 1 to show only ACGC items, 2 to show only ACWW items, 3 to show ACCF/LGTTC items, or 0 for all 3 games',
        'optionscode'    => 'text',
        'value'            => '0',
        'disporder'        => 2,
        'gid'            => intval($gid),
    );
    $catalog_setting_3 = array(

        'sid'            => NULL,
        'name'            => 'adminitems',
        'title'            => 'Admin Remove Items?',
        'description'    => 'Do you want admins to be able to remove items?',
        'optionscode'    => 'onoff',
        'value'            => 'off',
        'disporder'        => 3,
        'gid'            => intval($gid),
    ); 

Notice how there's no single quotes around NULL in my code.

TomNook08 · 03-13-2009 04:11 AM

I am testing it on my laptop with EasyPhp which is one of those Apache servers for computers and I was wondering would that (for some odd reason) cause me to get that error?

Splappy · 03-13-2009 04:19 AM

(03-13-2009 04:11 AM)TomNook08 Wrote: I am testing it on my laptop with EasyPhp which is one of those Apache servers for computers and I was wondering would that (for some odd reason) cause me to get that error?

No.
'NULL' is a string (letters and words) to MySQL.
NULL is an integer (number) to MySQL.
MySQL wanted an integer, and when you gave MySQL a string, it went "AHH THIS ISN'T AN INTEGER!!!" and caused an error.

TomNook08 · 03-13-2009 04:23 AM

Ohhh Ok well I just tried it again and I get a different error

Code:

Incorrect integer value: '' for column 'gid' at row 1

Today is just not my day

Splappy · 03-13-2009 04:28 AM

(03-13-2009 04:23 AM)TomNook08 Wrote: Ohhh Ok well I just tried it again and I get a different error

Code:

Incorrect integer value: '' for column 'gid' at row 1

Today is just not my day

Hmm...what's the code now, have you made any other changes?

TomNook08 · 03-13-2009 04:30 AM

I haven't made any changes since I removed the single quotes from NULL

***Nickman*** · 03-13-2009 04:39 AM

Just put 0 for default value.

TomNook08 · 03-13-2009 04:43 AM

Ok I did that and it says:

Code:

1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1

***Nickman*** · 03-13-2009 05:10 AM

make that 0 as default too

Possibly Related Threads...
Thread:		Author	Replies:	Views:	Last Post
	[Public Beta] Awards System	Nickman	88	1,649	Yesterday 03:39 AM Last Post: Polarbear541

New to MyBBSource?	Need Assistance?
About MyBBSource You Might Need To Register View Our Rules Looking to donate?	Mark Forums Read View Forum Staff Looking for a MyBB Host?

Threaded Mode \| Linear Mode Catalog System
Author	Message