[Addon] UCP Notepad 1.3.1

[Waleed]

It appears that if I change NOT NULL to NULL that it now works ^

Yes, that issue is a real pain. I'll have it NULL by default in the next release.

[ScrapbookSupplies Jeanne]

I tried to install using the "normal" installation and even after running the SQL Query twice am getting this error:

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'user_notepad' in 'field list' [1054]

SQL

SELECT user_notepad FROM phpbb3_users WHERE user_id=2

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_main.php
LINE: 220
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: ucp_main->main()

FILE: ucp.php
LINE: 310
CALL: p_master->load_active()

Wonder if you might know why??
Thanks!
Jeanne

[Waleed]

Your database table name is phpbb3_ instead of the default phpbb_, so that might be the problem. You ran the SQL query, but it didn't actually do anything to your actual forum's database.

Please run this SQL:

Code: Select all

ALTER TABLE phpbb3_users ADD user_notepad TEXT CHARACTER SET utf8 COLLATE utf8_bin;

[ScrapbookSupplies Jeanne]

Your database table name is phpbb3_ instead of the default phpbb_, so that might be the problem. You ran the SQL query, but it didn't actually do anything to your actual forum's database.

Please run this SQL:

Code: Select all

ALTER TABLE phpbb3_users ADD user_notepad TEXT CHARACTER SET utf8 COLLATE utf8_bin;

ough! I know better than that!

I had our forum disabled to update to 3.02 and to update the gallery, but the gallery did not update too well. I should have allowed a 'cool off' period to get "un-flustered" before doing this mod.

Thanks for pointing that out, sometimes we can't see the forest for the trees.

[ScrapbookSupplies Jeanne]

She loaded in and works perfectly!

What a great mos!!!

I have installed both the ACP and UCP notepads.

Thank you for such a wonderful mod!

[Waleed]

Glad to hear it's working! And thanks for finding it useful! I appreciate it.

[ScrapbookSupplies Jeanne]

Can you tell me what would cause this error when someone registers?

Thanks

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Field 'user_notepad' doesn't have a default value [1364]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

PS. Otherwise both the UCP and ACP Notepads work great!

[Waleed]

Is the field "NOT NULL" in your database? That is what causes this problem - please change it to "NULL" so that it can have an empty value. I don't have the SQL command that would do this, but you can do it in phpMyAdmin (or something similar).

This is my fault though, so I'm sorry for the trouble. I shouldn't have made it NOT NULL in the first place...

[ScrapbookSupplies Jeanne]

Is the field "NOT NULL" in your database? That is what causes this problem - please change it to "NULL" so that it can have an empty value. I don't have the SQL command that would do this, but you can do it in phpMyAdmin (or something similar).

This is my fault though, so I'm sorry for the trouble. I shouldn't have made it NOT NULL in the first place...

Thank you. I will try to get it figured out - I don't know how to do it either. If I figure it out I will post the solution back. Wondering if I could re-run the query, removing the word "not", but I'm not sure and a little afraid to try it.

I'll let you know.
Thanks,

[Jaymie1989]

Thank you. I will try to get it figured out - I don't know how to do it either. If I figure it out I will post the solution back. Wondering if I could re-run the query, removing the word "not", but I'm not sure and a little afraid to try it.

I'll let you know.
Thanks,

Here is the best way to do it. This will also help you Waleed
If you have added the SQL Entry from the install.xml then you need to do this

Code: Select all

ALTER TABLE phpbb_users DROP user_notepad;

and run this Entry

Code: Select all

ALTER TABLE phpbb_users ADD user_notepad TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;

If you have NOT ran the SQL Entry yet then when you do run this (Same as above)

Code: Select all

ALTER TABLE phpbb_users ADD user_notepad TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;

@ Waleed I think this would be good in your first post.