Not Solved SQL Error: 1364 - Field 'newpoints_items' doesn't have a default value
#3
Not Solved
(2021-02-10, 09:51 PM)Kojixus Wrote: If you know why this is happening, please let me know, or a fix-it will be great. I tried to remove a plugin I added last month, which didn't cause the issue. 

Thanks Smile

I am assuming by the issues identifying the plugin and sorta also identifying vers in question was say perhaps newpoints shop 1.7 or similar time period and or close to such of plugin? if so most of those related issues in 1.7 are easy to sort out by like say 2 alter table edits, 1 create table edits, a few of acp buttons edits and noted radios, etc, etc...

example of some basic things that are things one would have to touch on and such etc, etc, just for an example sake:
	$db->write_query("ALTER TABLE `".TABLE_PREFIX."users` ADD `newpoints_items` TEXT NOT NULL;");
	$db->write_query("ALTER TABLE `".TABLE_PREFIX."newpoints_grouprules` ADD `items_rate` DECIMAL(6,3) NOT NULL default 1.000;");

	//$db->write_query("ALTER TABLE `".TABLE_PREFIX."users` ADD `newpoints_items` TEXT NOT NULL;");

	//$db->write_query("ALTER TABLE `".TABLE_PREFIX."newpoints_grouprules` ADD `items_rate` DECIMAL(3,3) NOT NULL default '1';");



	  // `price` DECIMAL(16,2) NOT NULL default '0',

      `price` DECIMAL(16,2) NOT NULL default 0.00,



    //$buttons = "";
    $buttons = array();


    		//$form_container->output_row($lang->newpoints_shop_addedit_cat_expanded, $lang->newpoints_shop_addedit_cat_expanded_desc, $form->generate_yes_no_radio('expanded', 1, true, "", ""), 'expanded');


			$form_container->output_row($lang->newpoints_shop_addedit_cat_expanded, $lang->newpoints_shop_addedit_cat_expanded_desc, $form->generate_yes_no_radio('expanded', 1), 'expanded');

etc, etc...

ie: 1.7 edited and using newpoints 2.1.2
[Image: Plugins.png]

but I am not sure why one would want to do that on an outdated version when the actual current plugin is in say v1.9.4 and works well with np 2.1.2 without such issues and is freely avail via auth site?


ie: 1.9.4 not at all edited and using newpoints 2.1.2
[Image: Plugins-1.png]
Reply


Messages In This Thread
RE: SQL Error: 1364 - Field 'newpoints_items' doesn't have a default value - by censor_deeznutz - 2021-02-11, 02:10 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)