| Author |
 Topic  |
|
Hopeful
Junior Member
130 Posts |
 Posted - 29 January 2005 : 02:14:52
|
Private Messages Mod (Default)
Creating table(s).....
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Invalid default value for 'M_ID'
When I went to admin section and clicked on the mod a new window appeared with a bunch of code but this one line above was in red... At the end of the page box it said this...
"If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums "
Then it had a button to click that said "Finish"
I have not clicked finish because I did not know if I had an error due to the red lettering???
Do I click finish or does the red line mean there is an error?
While uploading it said a file pop_deleate.asp already exisited and wanted to know if I wanted to replace it and I answered no because I was not sure, could this be a problem?
All help appreciated, I am running the newest version of snitz on a mysql db.
Thank you! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 21 February 2005 14:59:40 |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 29 January 2005 : 02:36:07
|
I clicked finish and aparently there are errors... I now have 4 red lines of code...
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Invalid default value for 'M_ID'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMEMAIL'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMRECEIVE'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMBLOCKLIST'
Can someone explain what I need to do?
Thanks so much! |
Please explain everything in layman terms!!! |
 |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 29 January 2005 : 12:27:58
|
| Anyone?????????????? |
Please explain everything in layman terms!!! |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 29 January 2005 : 13:58:30
|
quote:
Originally posted by Hopeful
I clicked finish and aparently there are errors... I now have 4 red lines of code...
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Invalid default value for 'M_ID'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMEMAIL'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMRECEIVE'
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-max]Duplicate column name 'M_PMBLOCKLIST'
Can someone explain what I need to do?
Thanks so much!
For the first error- read this post: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55925 it looks like a similar error I had when I swicthed to a new server last week.
The other 3 errors.... well its saying DUPLICATE, which surley means that those table have already been created in your database. So go and check to see if they are there! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 01 February 2005 : 11:29:23
|
I already changed the option number and that worked for the forum to run without errors.
After that was taken care of I tried a new install of the private messages (I have never had this MOD installed before) this is the messages I get. As far as going to check if there are extra tables created in my database... How do I do that?
Thanks for the reply! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 01 February 2005 11:30:32 |
|
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 08 February 2005 : 21:20:42
|
| well whats your forum database? access or mysql? go into your database and check the members table for those duplicate cumomns. |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 08:59:23
|
How do I "go into my database" and check for the extra columns?
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 February 2005 : 09:27:52
|
Depends on what database you're using, as Gareth said. If it's Access, you can simply download it and open it up. If it's a SQL database, your host should have provided you with some way of accessing it online. If not, you should get in contact with them and ask them for details on how to do so.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 10:29:03
|
It is a mysql database and there is on option online with my server to manage my database, but since I don't know much about them I came here hoping someone could walk me through it. The online database manager asks me for a "querry" and I do not understand what I need to enter at that point.
Can anyone explain how the databases work and an easy way to access them or view them and make changes in the tables?
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 15:20:04
|
CREATE TABLE FORUM_PM( M_ID INT (11) DEFAULT '' NOT NULL auto_increment , M_SUBJECT varchar (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX smallint NULL DEFAULT 1,KEY FORUM_PM_M_ID(M_ID))
I found the problem in the data base...
some columns were created in other tables like forum_members but the forum_pm table was not created...
I tried to create the forum_pm table in the database and it gave me an error saying that I had to create at least 1 column...
out of curiosity I copied the text that said "create table forum_pm" straight from my /forum/admin_mod_dbsetup.asp (text shown above in red) and entered it as a querry and it gave me the same error as the /forum/admin_mod_dbsetup.asp page did...
Invalid default value for 'M_ID'
This leads me to believe there is a value wrong in this querry that is not allowing the table to be created in my database (MySQL)...
I do not know anything about writting querrys so can anyone tell me what value needs to be changed in this querry or can anyone write a querry that will allow the table to be created???
Thanks so much!!! |
Edited by - Hopeful on 18 February 2005 02:52:34 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 19 February 2005 : 03:19:33
|
Well I finally got that figured out, don't know how but I made the table and columns one by one in the data base and got Private messages installed!!! WHEW!!!
Only one problem..............
I am getting an error in ALL my topics... the first post shows, the second post has an error on it as follows:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cLng'
/forum/inc_func_common.asp, line 652
and no other post show in any topics beyond the second one with the error.
I did not change inc_func_common.asp as the instructions did not call for me to do so. Can anyone tell me how to correct this???
Thanks!!! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 19 February 2005 03:34:54 |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 19 February 2005 : 04:25:06
|
Got it Fixed!!!
The error was with the topics on my forum so I decided to try uploading my back up copy of topics.asp to see if the problem was gone... It was!!!
So I made another copy of my good backup copy of topics.asp and started to make the changes in the instructions from scratch and low and behold... when I got to the fourth instruction, something hit me... The instruction was this:
Find following: (about line 513)
Select All
rM_YAHOO = 5
Add the following directly below on line 514:
Select All
rM_PM = 6
When I added the line it made two number 6's in the string and I remember thinking "well that's weird" but It did not say to do anything else, so I left both 6's...
So I just decided to go to the revised copy and try changing all the numbers in the row to count up the rest of the way down and WOW............. It worked!!! Problem fixed there!!!
Maybe someone could update the read me file to include an instruction to do so (unless they already have  )
Anyway... Hope that is the end of errors with this mod install!!!
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 19 February 2005 : 04:47:44
|
quote:
Originally posted by modifichicci
Sql statement doesnt' want default value for autoincrement field.
That is a primary key.
Try to change to CREATE TABLE FORUM_PM( M_ID INT (11) auto_increment,....
This is the statement that it was trying to run automatically:
Private Messages Mod (Default)
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID INT (11) DEFAULT '' NOT NULL auto_increment , M_SUBJECT varchar (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX smallint NULL DEFAULT 1,KEY FORUM_PM_M_ID(M_ID))
After just changing and trying different stuff and not knowing what I was doing for hours... This is the one I stumbled onto that worked to create the table and one column (which it required at least one column...)
CREATE TABLE FORUM_PM(M_ID INT (11) DEFAULT " NOT NULL auto_increment " , KEY FORUM_PM_M_ID(M_ID))
One thing I noticed is it worked when I added the " after auto_increment (it was not in the default statement.)
Then I used this statement to add the columns one by one just changing the column name and value each time
ALTER TABLE FORUM_PM ADD M_PMRECEIVE int NULL DEFAULT 1
Maybe this will help someone else !!!
Thanks for your reply!!! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 19 February 2005 04:56:05 |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 19 February 2005 : 23:19:10
|
Found a glitch today and need some help please...
When you have read a PM sent to you and want to reply to the sender and click on the reply logo picture it redirects you to the default.asp page of the forum instead of giving you a reply box... Any Ideas how to correct this???
Thank! |
Please explain everything in layman terms!!! |
|
|
|
Topic |
|
Topic Locked
