| Author |
 Topic  |
|
tribaliztic
Senior Member
Sweden
1532 Posts |
 Posted - 30 August 2004 : 10:01:19
|
| Anyone tested @tomic's article mod on MySQL? I got some errors when running the dbs-file. |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 30 August 2004 : 10:58:26
|
well... I didn't copy the errors *doh* =(
If I run the dbs again I will get alot more errors, right?
I remember one error though, the FAQ-table did already exist.
|
/Tribaliztic
- www.gotlandrace.se -
|
 |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 04:17:36
|
Okay! Thanks alot! I'll try this asap!
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 04:23:38
|
Ok, I did the changes in the dbs-file, and got these errors:
----------------------------------------------------------------
@tomic's Article MOD for 3.4
Creating table(s)...
CREATE TABLE FORUM_ARTICLE_RATING( RATING_ID INT (11) DEFAULT '' NOT NULL auto_increment , COMMENTS text NULL , RATING int NULL , RATE_BY int NULL , LINK int NULL , RATE_DATE nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RATING_ID(RATING_ID))
CREATE TABLE FORUM_ARTICLE_RATING( RATING_ID INT (11) DEFAULT '' NOT NULL auto_increment , COMMENTS text NULL , RATING int NULL , RATE_BY int NULL , LINK int NULL , RATE_DATE nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RATING_ID(RATING_ID))
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RA' at line 1
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ARTICLE_BOOKMARKS( BOOKMARK_ID INT (11) DEFAULT '' NOT NULL auto_increment , B_MEMBERID int NOT NULL , FAQ int NOT NULL , FLDAUTO int NOT NULL ,KEY FORUM_ARTICLE_BOOKMARKS_BOOKMARK_ID(BOOKMARK_ID))
CREATE TABLE FORUM_ARTICLE_BOOKMARKS( BOOKMARK_ID INT (11) DEFAULT '' NOT NULL auto_increment , B_MEMBERID int NOT NULL , FAQ int NOT NULL , FLDAUTO int NOT NULL ,KEY FORUM_ARTICLE_BOOKMARKS_BOOKMARK_ID(BOOKMARK_ID))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_ARTICLE_BOOKMARKS' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FAQ( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar(50) NULL , DESCR varchar(255) NULL ,KEY FORUM_FAQ_FLDAUTO(FLDAUTO))
CREATE TABLE FORUM_FAQ( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar(50) NULL , DESCR varchar(255) NULL ,KEY FORUM_FAQ_FLDAUTO(FLDAUTO))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_FAQ' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_CHAPTER( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , FAQ_FLDAUTO int NULL DEFAULT 0, NAME varchar(50) NULL , ORDERINGFIELD varchar(50) NULL ,KEY FORUM_CHAPTER_FLDAUTO(FLDAUTO))
CREATE TABLE FORUM_CHAPTER( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , FAQ_FLDAUTO int NULL DEFAULT 0, NAME varchar(50) NULL , ORDERINGFIELD varchar(50) NULL ,KEY FORUM_CHAPTER_FLDAUTO(FLDAUTO))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_CHAPTER' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_QUESTION( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , CHAPTER_FLDAUTO int NULL DEFAULT 0, QUESTION varchar(255) NULL , AUTHOR varchar(50) NULL , POST_DATE nchar(50) NULL , UPDATE_DATE nchar(50) NULL , HEADER_ID int NULL , ANSWER text NULL , ORDERINGFIELD varchar(10) NULL , HIT int NULL DEFAULT 0, RATING int NULL DEFAULT 0, VOTES int NULL DEFAULT 0, SHOW int NULL DEFAULT 0, ADDED_BY int NULL ,KEY FORUM_QUESTION_FLDAUTO(FLDAUTO))
CREATE TABLE FORUM_QUESTION( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , CHAPTER_FLDAUTO int NULL DEFAULT 0, QUESTION varchar(255) NULL , AUTHOR varchar(50) NULL , POST_DATE nchar(50) NULL , UPDATE_DATE nchar(50) NULL , HEADER_ID int NULL , ANSWER text NULL , ORDERINGFIELD varchar(10) NULL , HIT int NULL DEFAULT 0, RATING int NULL DEFAULT 0, VOTES int NULL DEFAULT 0, SHOW int NULL DEFAULT 0, ADDED_BY int NULL ,KEY FORUM_QUESTION_FLDAUTO(FLDAUTO))
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'SHOW int NULL DEFAULT 0, ADDED_BY int NULL ,KEY FORUM_QUESTION_FLDAUTO(FLDAUTO))' at line 1
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (1,1,'General','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (2,1,'Test1','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (3,1,'Test2','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_QUESTION (FLDAUTO,CHAPTER_FLDAUTO,QUESTION,AUTHOR,POST_DATE,UPDATE_DATE,ANSWER,ORDERINGFIELD,SHOW,ADDED_BY) VALUES (1,1,'General Stuff','Admin','20020405181432','20020405181432','Article Contents go here','ZZZZZZ',1,1)
INSERT INTO FORUM_QUESTION (FLDAUTO,CHAPTER_FLDAUTO,QUESTION,AUTHOR,POST_DATE,UPDATE_DATE,ANSWER,ORDERINGFIELD,SHOW,ADDED_BY) VALUES (1,1,'General Stuff','Admin','20020405181432','20020405181432','Article Contents go here','ZZZZZZ',1,1)
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'SHOW,ADDED_BY) VALUES (1,1,'General Stuff','Admin','20020405181432','20020405181' at line 1
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
-2147467259 | SQLState: 42S22
Native Error Code: 1054
[TCX][MyODBC]Unknown column 'FLDAUTO' in 'field list'
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
----------------------------------------------------------------
Also, can I change the SHOW-field already in the dbs-file?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 04:53:26
|
I edited the file and reuploaded it, I'll try again and change the name to be sure I'm running the corrected file =)
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 04:58:16
|
Ok, and I ran this again (checked that it was the edited file), edited the "COMMENTS" and "SHOW" lines and got these errors:
-new- @tomic's Article MOD for 3.4
Creating table(s)...
CREATE TABLE FORUM_ARTICLE_RATING( RATING_ID INT (11) DEFAULT '' NOT NULL auto_increment , COMMENTS text NULL , RATING int NULL , RATE_BY int NULL , LINK int NULL , RATE_DATE nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RATING_ID(RATING_ID))
CREATE TABLE FORUM_ARTICLE_RATING( RATING_ID INT (11) DEFAULT '' NOT NULL auto_increment , COMMENTS text NULL , RATING int NULL , RATE_BY int NULL , LINK int NULL , RATE_DATE nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RATING_ID(RATING_ID))
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'nvarchar(50) NULL , FAQ int NULL , FLDAUTO int NULL ,KEY FORUM_ARTICLE_RATING_RA' at line 1
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ARTICLE_BOOKMARKS( BOOKMARK_ID INT (11) DEFAULT '' NOT NULL auto_increment , B_MEMBERID int NOT NULL , FAQ int NOT NULL , FLDAUTO int NOT NULL ,KEY FORUM_ARTICLE_BOOKMARKS_BOOKMARK_ID(BOOKMARK_ID))
CREATE TABLE FORUM_ARTICLE_BOOKMARKS( BOOKMARK_ID INT (11) DEFAULT '' NOT NULL auto_increment , B_MEMBERID int NOT NULL , FAQ int NOT NULL , FLDAUTO int NOT NULL ,KEY FORUM_ARTICLE_BOOKMARKS_BOOKMARK_ID(BOOKMARK_ID))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_ARTICLE_BOOKMARKS' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FAQ( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar(50) NULL , DESCR varchar(255) NULL ,KEY FORUM_FAQ_FLDAUTO(FLDAUTO))
CREATE TABLE FORUM_FAQ( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar(50) NULL , DESCR varchar(255) NULL ,KEY FORUM_FAQ_FLDAUTO(FLDAUTO))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_FAQ' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_CHAPTER( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , FAQ_FLDAUTO int NULL DEFAULT 0, NAME varchar(50) NULL , ORDERINGFIELD varchar(50) NULL ,KEY FORUM_CHAPTER_FLDAUTO(FLDAUTO))
CREATE TABLE FORUM_CHAPTER( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , FAQ_FLDAUTO int NULL DEFAULT 0, NAME varchar(50) NULL , ORDERINGFIELD varchar(50) NULL ,KEY FORUM_CHAPTER_FLDAUTO(FLDAUTO))
-2147467259 | SQLState: S1000
Native Error Code: 1050
[TCX][MyODBC]Table 'FORUM_CHAPTER' already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_QUESTION( FLDAUTO INT (11) DEFAULT '' NOT NULL auto_increment , CHAPTER_FLDAUTO int NULL DEFAULT 0, QUESTION varchar(255) NULL , AUTHOR varchar(50) NULL , POST_DATE nchar(50) NULL , UPDATE_DATE nchar(50) NULL , HEADER_ID int NULL , ANSWER text NULL , ORDERINGFIELD varchar(10) NULL , HIT int NULL DEFAULT 0, RATING int NULL DEFAULT 0, VOTES int NULL DEFAULT 0, SHOW_QUESTION int NULL DEFAULT 0, ADDED_BY int NULL ,KEY FORUM_QUESTION_FLDAUTO(FLDAUTO))
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (1,1,'General','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (2,1,'Test1','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CHAPTER (FLDAUTO,FAQ_FLDAUTO,NAME,ORDERINGFIELD) VALUES (3,1,'Test2','ZZZZZZ')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_QUESTION (FLDAUTO,CHAPTER_FLDAUTO,QUESTION,AUTHOR,POST_DATE,UPDATE_DATE,ANSWER,ORDERINGFIELD,SHOW_QUESTION,ADDED_BY) VALUES (1,1,'General Stuff','Admin','20020405181432','20020405181432','Article Contents go here','ZZZZZZ',1,1)
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
-2147467259 | SQLState: 42S22
Native Error Code: 1054
[TCX][MyODBC]Unknown column 'FLDAUTO' in 'field list'
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums |
/Tribaliztic
- www.gotlandrace.se -
|
Edited by - tribaliztic on 31 August 2004 05:54:51 |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 07:09:43
|
Ok, changed from nvarchar to varchar in the "comments"-line, now I only get errors on the tables that already exist and this one:
Adding new records..
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
INSERT INTO FORUM_FAQ (FLDAUTO,NAME,DESCR) VALUES (1,'Main Category','Description of category goes here')
-2147467259 | SQLState: 42S22
Native Error Code: 1054
[TCX][MyODBC]Unknown column 'FLDAUTO' in 'field list'
When there is an error about a table already existing, aren't the fields in the table updated/created anyways?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 07:15:57
|
Solved it with a band-aid =)
Changed the "FAQ" to "ARTICLE_FAQ" and the dbs went trough nicely. Now I only have to edit the code to reflect my changes. I guess I'll be back with more errors then ;)
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 31 August 2004 : 10:09:52
|
Okay, I did get this running.. sorta..
I get alot of "Type Mismatch 'cint'"-errors, what's causing this?
Did a search both here and over at SHN Forum with no luck.
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 31 August 2004 : 12:44:12
|
Renaming the FAQ field is a really good idea. I am going to update this MOD over the next few weeks and change some file and database field names to something more suitable in a clean install. I have also added a few new features like META tag fields for keywords and a description. The description META is also used as article "Teasers" on the homepage and at the top of the article like you see on many websites. This also made the query execute faster since before it was grabbing the entire article for a teaser but only displaying the first 250 characters. That's really a drain as you can imagine.
So I am going to clean this up further, add the new improvements and a few other required MODs and release it all together in one neat package that should save everyone a lot of headache.
@ |
SportsBettingAcumen.com |
Edited by - @tomic on 31 August 2004 12:44:47 |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 01 September 2004 : 02:56:31
|
Okay, then I'll quit trying 'til you get this working. If noone have a quick solution to my problem that is?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Topic |
|
|
|
Topic Locked
