| Author |
 Topic  |
|
Nijii
Starting Member
Greenland
49 Posts |
 Posted - 31 January 2006 : 17:16:23
|
quote:
Originally posted by Classicmotorcycling
Update - Added 31 Jan 2006:
Ability to use with no other MODs installed (Added extra code to allow for the Language part with-out interfering with other Mods)
Thanks for the update. I have just downloaded the files and added them to my forum. Fantastic!
Is there any mod one can use to add photos dish with?
< |
 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 31 January 2006 : 19:00:51
|
I am glad that you got it working... quote:
Originally posted by Nijii
Thanks for the update. I have just downloaded the files and added them to my forum. Fantastic!
Is there any mod one can use to add photos dish with?
I am working on getting the forum code to work with it now. I will not allow HTML code to work with it as it would open a big security hole in it.
I will look at adding pictures to it, maybe not with uploading, as I don't have the time for that side at the moment.  
< |
Cheers,
David Greening |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 01 February 2006 : 03:12:42
|
Anyone got this working with MySQL?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
JBaldwin
Junior Member
USA
137 Posts |
Posted - 02 February 2006 : 12:24:37
|
When I add a recipe, I needed to edit it. When I try to edit the recipe, the section I try editing is deleted and I cannot add anything to that area again? I entered ingredients and realized I made an error. I went in to edit it, clicked on Update First Step and then went back to main forum (via the link). Now the ingredients for that recipe are gone and I cannot edit them to show up again?
So...I added another recipe (the same one) and then decided to delete the wrong one, now I cannot delete it. If i click on Delete Recipe, it ends up bringing me back to the Edit Recipe section which didn't work for me before? I'm a bit confused? LOl Can someone help me out? I am using an Access DB and of course the only changes I made were to inc_header.asp so I don't think it was something I did?
Thanks in advance.
Jeff B
EDIT: Sorry, I should have posted this in MOD Implementation. You can see what I mean by viewing the recipe section: RECIPE< |
AbsolutelyFreerolls.com - Poker Freeroll Listings, Poker Forum and Poker News
|
Edited by - JBaldwin on 02 February 2006 12:27:27 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 03 February 2006 : 01:48:20
|
Working on it this week-end as I have been real busy and will have it sorted. I have to replicate the error first, then I will have fix somethime this week-end. I never noticed it before, but we are all prone to forgetting something.  I am not sure why it would be doing it, but I will find out and update the code.
I will also test on MySQL and find out what the issue is there, I wil also test on MS SQL 2000. I have only tested on Access as I have not had the others installed on my server before today.
< |
Cheers,
David Greening |
|
|
|
JBaldwin
Junior Member
USA
137 Posts |
Posted - 03 February 2006 : 02:15:51
|
Uh Oh. Another thing to look into as well. After I submitted a recipe and I filled in my username as the CONTRIBUTOR; When another user logs in and views the same recipe that I just submitted, THAT users username shows as the one who contributed it. One of my users brought this to my attention.
He emailed me and said he saw the new recipe section and checked it out. It said he contributed the recipes that I had put up. LOL. He was just a little confused and was left scratching his head. LOL, no big deal but thought you should know.
Jeff B.< |
AbsolutelyFreerolls.com - Poker Freeroll Listings, Poker Forum and Poker News
|
|
|
|
Nijii
Starting Member
Greenland
49 Posts |
Posted - 08 March 2006 : 18:24:55
|
What code should I add to the recipe book so that only members of the forum can post new recipes but others can only see?
The reason for asking is that I have started getting all kinds of links being posted as new recipes although I have to approve them first. I have to deleted 37 og such entries daily for the past 4 days:-(
Disregard: I found my answer in the following topic http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61210< |
Edited by - Nijii on 10 March 2006 12:43:55 |
|
|
|
seanbol
Starting Member
13 Posts |
Posted - 12 June 2007 : 12:51:15
|
Is the recipe mod work with Access also?
If so, then why is it working???
I got error on instulation :(< |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 12 June 2007 : 13:11:17
|
| yes it also works with access. You will want to post your error so someone will be able to help you with it. I had it running on an access database a few months back.< |
|
|
|
seanbol
Starting Member
13 Posts |
Posted - 12 June 2007 : 13:59:14
|
Here is my error when I click on the link recipe.asp
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW = 1' at line 1
/forum/recipe.asp, line 1902
< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 12 June 2007 : 14:15:05
|
| Are you using Access or MySQL? the error you posted is for the MyODBC drivers - used with MySQL...< |
|
|
|
seanbol
Starting Member
13 Posts |
Posted - 12 June 2007 : 17:42:11
|
Access. But I thought the MOD is in Access!!!!
Do I need to download a different MOD?
Where am I wrong?< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 12 June 2007 : 20:45:45
|
| The MOD uses whatever database you use for the forum... just for clarification, are you using a Windows host and IIS?< |
|
|
|
seanbol
Starting Member
13 Posts |
Posted - 13 June 2007 : 18:23:18
|
Then why am I getting MySQL errors?
I have uploaded the 2.2.< |
|
|
|
seanbol
Starting Member
13 Posts |
Posted - 13 June 2007 : 18:43:18
|
This is what happens when I go to "MOD Setup" and install the Recipe. There are some red errors that I will indicate with <<------
Dropping Table..
DROP TABLE FORUM_RECIPE
-2147467259 | [TCX][MyODBC]Unknown table 'forum_recipe' <<-------------------------------
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RECIPE( RECIPE_ID INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar (150) NULL , URL varchar (255) NULL , KEYWORD varchar (255) NULL , DESCRIPTION text NULL , INGREDIENTS text NULL , POST_DATE varchar (100) NULL , HIT int NULL DEFAULT 0, CATEGORY int NULL DEFAULT 0, PARENT_ID int NULL DEFAULT 0, SHOW int NULL DEFAULT 0, BADLINK int NULL DEFAULT 0, RATING int NULL DEFAULT 0, VOTES int NULL DEFAULT 0, FILESIZE varchar (100) NULL , LICENSE varchar (100) NULL , LANG varchar (100) NULL , PLATFORM varchar (100) NULL , PUBLISHER varchar (100) NULL , PUBLISHER_URL varchar (100) NULL , UPLOADER varchar (100) NULL ,KEY FORUM_RECIPE_RECIPE_ID(RECIPE_ID))
CREATE TABLE FORUM_RECIPE( RECIPE_ID INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar (150) NULL , URL varchar (255) NULL , KEYWORD varchar (255) NULL , DESCRIPTION text NULL , INGREDIENTS text NULL , POST_DATE varchar (100) NULL , HIT int NULL DEFAULT 0, CATEGORY int NULL DEFAULT 0, PARENT_ID int NULL DEFAULT 0, SHOW int NULL DEFAULT 0, BADLINK int NULL DEFAULT 0, RATING int NULL DEFAULT 0, VOTES int NULL DEFAULT 0, FILESIZE varchar (100) NULL , LICENSE varchar (100) NULL , LANG varchar (100) NULL , PLATFORM varchar (100) NULL , PUBLISHER varchar (100) NULL , PUBLISHER_URL varchar (100) NULL , UPLOADER varchar (100) NULL ,KEY FORUM_RECIPE_RECIPE_ID(RECIPE_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW int NULL DEFAULT 0, BADLINK int NULL DEFAULT 0, RATING int <<-----------------
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RECIPE_CATEGORIES( CAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT_NAME varchar (100) NULL ,KEY FORUM_RECIPE_CATEGORIES_CAT_ID(CAT_ID))
Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RECIPE_RATING( RATING_ID INT (11) DEFAULT '' NOT NULL auto_increment , COMMENTS text NULL , RATING int NULL DEFAULT 0, RATE_BY int NULL DEFAULT 0, RECIPE int NULL DEFAULT 0, RATE_DATE varchar (100) NULL ,KEY FORUM_RECIPE_RATING_RATING_ID(RATING_ID))
Table created succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_RECIPE_SUBCATEGORIES( SUBCAT_ID INT (11) DEFAULT '' NOT NULL auto_increment , SUBCAT_NAME varchar (100) NULL , CAT_ID int NULL DEFAULT 0,KEY FORUM_RECIPE_SUBCATEGORIES_SUBCAT_ID(SUBCAT_ID))
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_RECIPE_CATEGORIES (CAT_NAME) VALUES ('Default')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_RECIPE_SUBCATEGORIES (SUBCAT_NAME, CAT_ID) VALUES ('Default', '1')
Value(s) updated succesfully
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
< |
|
|
|
Topic |
|
Mod: Recipe Book 2.1
