MyBB-Plugins Forums
NewPoints 1.9.9 - Printable Version

+- MyBB-Plugins Forums (http://forums.mybb-plugins.com)
+-- Forum: Archived Forums (http://forums.mybb-plugins.com/Forum-Archived-Forums)
+--- Forum: MyBB 1.6.x (http://forums.mybb-plugins.com/Forum-MyBB-1-6-x)
+---- Forum: NewPoints (http://forums.mybb-plugins.com/Forum-NewPoints)
+---- Thread: NewPoints 1.9.9 (/Thread-NewPoints-1-9-9)



RE: NewPoints 1.7 - karlim - 12-04-2010

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1101 - BLOB/TEXT column 'type' can't have a default value
Query:
CREATE TABLE `mybb_newpoints_settings` ( `sid` int(10) UNSIGNED NOT NULL auto_increment, `plugin` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL default '', `title` varchar(100) NOT NULL default '', `description` text NOT NULL, `type` text NOT NULL default '', `value` text NOT NULL default '', `disporder` smallint(5) UNSIGNED NOT NULL default '0', PRIMARY KEY (`sid`) ) TYPE=MyISAM



RE: NewPoints 1.7 - Diogo Parrinha - 12-04-2010

(12-04-2010, 12:07 PM)mazin Wrote: hi every one... thanks for this Great Job ...
i have a question i am new with these Wink
,,,,,,,,,,,,,,,,
Q: if i use for my forum, what happing to our users ? is that any thing to give them a point ? or them must start from 0 like a new user for this system ?

You can use the Maintenance page to calculate all current points.


(12-04-2010, 09:59 PM)karlim Wrote: MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1101 - BLOB/TEXT column 'type' can't have a default value
Query:
CREATE TABLE `mybb_newpoints_settings` ( `sid` int(10) UNSIGNED NOT NULL auto_increment, `plugin` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL default '', `title` varchar(100) NOT NULL default '', `description` text NOT NULL, `type` text NOT NULL default '', `value` text NOT NULL default '', `disporder` smallint(5) UNSIGNED NOT NULL default '0', PRIMARY KEY (`sid`) ) TYPE=MyISAM

Oops my bad.

In the plugin file, please use this:
PHP Code:
      `descriptiontext NOT NULL,
      `
typetext NOT NULL,
      `
valuetext NOT NULL

Instead of:
PHP Code:
      `descriptiontext NOT NULL,
      `
typetext NOT NULL default '',
      `
valuetext NOT NULL default ''



RE: NewPoints 1.7 - karlim - 12-05-2010

thank you
it's OK now,but when
when i click on the settings,
it shows
"Main Settings (0 Settings)
These settings come with NewPoints by default.
Income Settings (0 Settings)
"


click on "Forum Rules" it shows

"MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mysql.mybb_newpoints_forumrules' doesn't exist
Query:
SELECT * FROM mybb_newpoints_forumrules ORDER BY rid ASC"

click on "Group Rules"
it show like that
"MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mysql.mybb_newpoints_grouprules' doesn't exist
Query:
SELECT * FROM mybb_newpoints_grouprules ORDER BY rid ASC
"

Statistics

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'newpoints' in 'field list'
Query:
SELECT uid,username,newpoints FROM mybb_users ORDER BY newpoints DESC LIMIT 0

ANd when i drop it

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Can't DROP 'newpoints'; check that column/key exists
Query:
ALTER TABLE `mybb_users` DROP `newpoints`;


how should i do?



RE: NewPoints 1.7 - Diogo Parrinha - 12-05-2010

You must uninstall NewPoints and install it again.


RE: NewPoints 1.7 - karlim - 12-05-2010

it can't uninstall
but everything's ok when i change another mysql version


RE: NewPoints 1.7 - Diogo Parrinha - 12-05-2010

(12-05-2010, 09:39 PM)karlim Wrote: it can't uninstall
but everything's ok when i change another mysql version

Hmm, changing MySQL version shouldn't fix anything since the data is still there. What you must do now is copy paste the link to your URL bar and change the uninstall to install and the deactivate to activate so it installs again. It will probably give more errors but then you should be able to uninstall correctly.


RE: NewPoints 1.7 - jess - 12-07-2010

(12-04-2010, 03:01 AM)Pirata Nervo Wrote:
(12-04-2010, 02:59 AM)wethegreenpeople Wrote:
(12-04-2010, 02:42 AM)Pirata Nervo Wrote:
(12-04-2010, 02:31 AM)wethegreenpeople Wrote:
(12-03-2010, 11:21 PM)Pirata Nervo Wrote: What did you do to get that error? Anything special?

Nope, just installed it. But my super awesome awesomeness probably just caused your plugin to overload with fear. Rolleyes xD haha

Which files do you have in the Newpoints' settings folder?

Forums rules, group rules, log, maintenance, module_meta, plugin, settings, stats, upgrades.

I meant the plugins folder, sorry.

I have the same issue :S


RE: NewPoints 1.7 - Diogo Parrinha - 12-07-2010

And which files do you have in the plugins folder?


RE: NewPoints 1.7 - jess - 12-07-2010

images
languages
upgrades
index
newpoints_bank
newpoints_hello
newpoints_lottery

*Edit*
I reinstalled the Shop and newpoints_hello and it fixed itself.
Thanks


RE: NewPoints 1.7 - Diogo Parrinha - 12-07-2010

Oh well, I still have no clue why it displayed that error though :S