Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 7 Years, 3 Months, 1 Week ago [Error Message] SQL Error: 1364 - Field 'views' doesn't have a default value
#11
Solved: 7 Years, 3 Months, 1 Week ago
Run the following query instead.
ALTER TABLE mybb_users MODIFY views int NOT NULL DEFAULT '0'

Whichever profile views plug-in you are using probably needs updating.
#12
Solved: 7 Years, 3 Months, 1 Week ago
(2014-06-08, 05:07 AM)Omar G. Wrote: Run the following query instead.
ALTER TABLE mybb_users MODIFY views int NOT NULL DEFAULT '0'

Whichever profile views plug-in you are using probably needs updating.

I had all plugins deactivated, and the problem still happened. But thank you it fixed the problem

Also now im getting a error when i try to activate certain plugins

SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('NULL','forumviews','Forum Views','Show how many users have viewed forum','1','0')
#13
Solved: 7 Years, 3 Months, 1 Week ago
You are using too outdated plug-ins. Please list them all here, I may as well guest which ones need to be updated (pretty sure there is no plug-in in the mods site I haven't tested before Toungue).

If you want to give it a go, try opening all your plug-in files, search and remove all lines similar to this:
'gid' => NULL,

'gid' => 'NULL',

'sid' => NULL,

'sid' => 'NULL',
#14
Solved: 7 Years, 3 Months, 1 Week ago
Since the original issue seems to be fixed I will be marking this as solved.


Forum Jump:


Users browsing this thread: 1 Guest(s)