- Moderated by:
- Support Team
Install problems with MySQL
-
- rank:
-
Helper
- registered:
- January 2004
- Status:
- offline
- last visit:
- 03.07.07
- Posts:
- 137
This problem is giving me fits!@!!!!$)*!@#$&*()$!&*() ARRRRGGGG!!!!!
Ok... now that I got that out of the way. I've found some other parts that don't like the strict mode, for example, when new users try to register they get an error saying,
Code
1366: Incorrect integer value: '' for column 'pn_user_theme' at row 1
or when using PNphpBB2 and you add a new post if you don't pick a message icon it has an error. I fixed this by editing a setting in a PNphpBB2 cache file and changing a value from "NONE" to "0" But right now the users one is really bothering me. So I've tried to disable the strict mode in SQL, I figure if it's something new that we didn't need before, then I don't need it now, especially if it jacks up everything I want to use.
So here's what I've tried, opened my SQL/my.ini file and edited the SQL-mode line from:
toCode
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"Ok now I can't create any new tables... I triedCode
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
No love either, so I triedCode
sql-mode="NO_ENGINE_SUBSTITUTION"
nope, still won't create the table. Anyone know the proper way to disable this "Strict Mode?"Code
sql-mode=""
--
Member of the PNphpBB Development Team
-
- rank:
-
Steering Committee
- registered:
- December 2002
- Status:
- offline
- last visit:
- 09.11.08
- Posts:
- 13413
Take a look at the MySQL manual - that's usually a good place to look.
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
-
- rank:
-
Helper
- registered:
- January 2004
- Status:
- offline
- last visit:
- 03.07.07
- Posts:
- 137
Ok, I forgot to mention that I've searched and read every part of the MySQL manual... :P oops.
Ok... well I've been spending a lot of time with this and I'm sure that there are others here who have dealt with this before themselves. The MySQL manual says that you can change the mysql_modes varible withSo I triedCode
SET [GLOBAL|SESSION] sql_mode='modes'and the result saysCode
SET global sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';hmmm nothing affected? I tryCode
Query OK, 0 rows affected (0.01 sec)and I getCode
SELECT @@global.sql_mode;So then I try clearing it completly and it works.... :DCode
mysql> +-------------------------------------------------------------------------------
-----------------------------------------------------------------------+
| @@global.sql_mode
|
+-------------------------------------------------------------------------------
-----------------------------------------------------------------------+
| STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_D
IVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------
-----------------------------------------------------------------------+
1 row in set (0.03 sec)Code
With it set to nothing everything seems to work with PostNuke, I can install a new version, I can register new accounts, but I have a feeling that there are things I just enabled by getting rid of all the other variables there that I might want to use... Oh and if I try the command with only what I want to show up in the command, it still loads everything that was there originally...
If anyone has experienced this and knows how to fix it, please help.
PS Sorry if it seems like most of my posts from an "agitated" state, but I'm really about to start doing what HammerHeads little icon is doing and I don't want to break any more monitors.... :P One of mine died last week :( Luckily I had 3 more sitting in a closet here :D
--
Member of the PNphpBB Development Team
|
