Web Wiz Support and Community Forums : to MySql https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 13:51:34 +0000 Thu, 28 Jul 2005 17:26:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15414 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[to MySql : I spent some time converting WWF...]]> https://forums.webwiz.net/to-mysql_topic15414_post87836.html#87836 Author: JJLatWebWiz
Subject: 15414
Posted: 28 July 2005 at 5:26pm

I spent some time converting WWF 7.01 to run on MySQL.  It's not a simple process.  WWF makes extensive use of recordset pages, which of course MySQL does not support.  Simulating the functionality for MySQL is fairly easy, but it has to be applied to almost every file, which means once you're done, all future patches and upgrades will require the same work.  I did it though because I needed better performance than Access and didn't want to pay the premium for a host with MS SQL.
 
Good luck.
]]> Thu, 28 Jul 2005 17:26:53 +0000 https://forums.webwiz.net/to-mysql_topic15414_post87836.html#87836 <![CDATA[to MySql : please read the thread within...]]> https://forums.webwiz.net/to-mysql_topic15414_post85003.html#85003 Author: dj air
Subject: 15414
Posted: 13 June 2005 at 11:05am

please read the thread within the suggestions forum.

it was discussed ages ago and he said no,

then recently with MySQL developments it maybe possible, but if thereis ever lickly to be it will be a long time yet, as he want s to finishV8, and he has other commitments.

so you are talking months maybe a year year and a half.. no reall time frame if any.


]]> Mon, 13 Jun 2005 11:05:04 +0000 https://forums.webwiz.net/to-mysql_topic15414_post85003.html#85003 <![CDATA[to MySql : -boRg- wrote:The present...]]> https://forums.webwiz.net/to-mysql_topic15414_post84998.html#84998 Author: DoltHeadRapper
Subject: 15414
Posted: 13 June 2005 at 9:43am

Originally posted by -boRg- -boRg- wrote:

The present version will not work with mySQL as mySQL doesn't fullysupport ADO and the SQL used for mySQL is different to that used inAccess or SQL Server


Do you ever plan to make a version that will run on MySQL right out of the box?
]]> Mon, 13 Jun 2005 09:43:32 +0000 https://forums.webwiz.net/to-mysql_topic15414_post84998.html#84998 <![CDATA[to MySql : following is the sql for MySql: because...]]> https://forums.webwiz.net/to-mysql_topic15414_post84993.html#84993 Author: wang
Subject: 15414
Posted: 13 June 2005 at 4:54am

following is the sql for MySql:
 
because read is reserved word, i have to change read to reads in table tblpermission and tblforum.
 
the forum is works with mysql, but some sql string need to be changed inside the programe. i am not good at sql, if anyone done, please give a grant instruction.
 
-----------------------------------------------------------
SET FOREIGN_KEY_CHECKS=0;
use test;
CREATE TABLE tblconfiguration (
  website_name varchar(50) NOT NULL default '',
  forum_name varchar(50) default NULL,
  forum_path varchar(70) default NULL,
  website_path varchar(70) default NULL,
  forum_email_address varchar(50) default NULL,
  email_notify tinyint(4) default NULL,
  mail_component varchar(10) default NULL,
  mail_server varchar(60) default NULL,
  IE_editor tinyint(4) default NULL,
  L_code tinyint(4) default NULL,
  Topics_per_page int(11) default NULL,
  Title_image varchar(70) default NULL,
  Text_link tinyint(4) default NULL,
  Emoticons tinyint(4) default NULL,
  Avatar tinyint(4) default NULL,
  Email_activate tinyint(4) default NULL,
  Email_post tinyint(4) default NULL,
  Hot_views int(11) default NULL,
  Hot_replies int(11) default NULL,
  Private_msg tinyint(4) default NULL,
  No_of_priavte_msg int(11) default NULL,
  Threads_per_page int(11) default NULL,
  Spam_seconds int(11) default NULL,
  Spam_minutes int(11) default NULL,
  Vote_choices int(11) default NULL,
  Email_sys tinyint(4) default NULL,
  Upload_img_path varchar(50) default NULL,
  Upload_img_types varchar(50) default NULL,
  Upload_img_size int(11) default NULL,
  Upload_files_path varchar(50) default NULL,
  Upload_files_type varchar(50) default NULL,
  Upload_files_size int(11) default NULL,
  Upload_avatar tinyint(4) default NULL,
  Upload_avatar_path varchar(50) default NULL,
  Upload_avatar_types varchar(50) default NULL,
  Upload_avatar_size int(11) default NULL,
  Upload_component varchar(10) default NULL,
  Active_users tinyint(4) default NULL,
  Forums_closed tinyint(4) default NULL,
  Show_edit tinyint(4) default NULL,
  Process_time tinyint(4) default NULL,
  Flash tinyint(4) default NULL,
  Show_mod tinyint(4) default NULL,
  Reg_closed tinyint(4) default NULL,
  PRIMARY KEY  (website_name)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert  into tblconfiguration values
 ('My Website', 'Web Wiz Forums', 'http://www.myweb.coo/forum', 'http://www.webwizforums.com',
 'forum@myweb.coo', 1, 'CDONTS', '', 1, 1, 12, 'forum_images/web_wiz_forums.gif', 1, 1, 1, 0, 1, 40, 10, 1, 25, 10, 15, 9, 6, 1, 'uploads', 'jpg;jpeg;gif;png', 35,
 'uploads', 'zip;rar', 500, 1, 'uploads', 'jpg;jpeg;gif;png', 15, 'AspUpload', 1, 0, 1, 1, 0, 0, 0);

CREATE TABLE tblauthor (
  Author_ID int(11) NOT NULL default '0',
  Group_ID int(11) default NULL,
  Username varchar(30) default NULL,
  Real_name varchar(40) default NULL,
  User_code varchar(50) default NULL,
  Password varchar(50) default NULL,
  Salt varchar(30) default NULL,
  Author_email varchar(75) default NULL,
  Show_email tinyint(4) default NULL,
  Homepage varchar(50) default NULL,
  Location varchar(60) default NULL,
  MSN varchar(75) default NULL,
  Yahoo varchar(75) default NULL,
  ICQ varchar(20) default NULL,
  AIM varchar(75) default NULL,
  Occupation varchar(60) default NULL,
  Interests varchar(160) default NULL,
  DOB datetime default NULL,
  Signature longtext,
  Attach_signature tinyint(4) default NULL,
  No_of_posts int(11) default NULL,
  Join_date datetime default NULL,
  Active tinyint(4) default NULL,
  Avatar varchar(100) default NULL,
  Avatar_title varchar(70) default NULL,
  Last_visit datetime default NULL,
  Time_offset char(1) default NULL,
  Time_offset_hours int(11) default NULL,
  Date_format varchar(10) default NULL,
  Rich_editor tinyint(4) default NULL,
  Reply_notify tinyint(4) default NULL,
  PM_notify tinyint(4) default NULL,
  PRIMARY KEY  (Author_ID),
  KEY fi0 (Group_ID),
  CONSTRAINT tblauthor_ibfk_1 FOREIGN KEY (Group_ID) REFERENCES tblgroup (Group_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 

insert  into tblauthor values
(1, 1, 'administrator', null, 'administrator2FC73499BAC5A41', 'A85B3E67CFA695D711570FB9822C0CF82871903B', '72964E7', null, 0, null, null, null, null, null,
 null, null, null, null, null, 0, 0, '2003-10-01 19:55:43', 1, null, null, '2003-02-08 15:06:43', '+', 0, 'dd/mm/yy', 1, 0, 0),
(2, 2, 'Guests', null, 'Guest48CEE9Z2849AE95A6', '6734DDD7A6A6C9F4D34945B0C9CF9677F3221EC9', 'E4AC',
 null, 0, null, null, null, null, null, null, null, null, null, null, 0, 0, '2003-10-01 15:24:22', 1, null, null, '2003-01-25 15:24:22', '+', 0, 'dd/mm/yy', 1, 0, 0);
 
CREATE TABLE tblbanlist (
  Ban_ID int(11) NOT NULL default '0',
  IP varchar(30) default NULL,
  Email varchar(60) default NULL,
  PRIMARY KEY  (Ban_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
CREATE TABLE tblbuddylist (
  Address_ID int(11) NOT NULL default '0',
  Author_ID int(11) default NULL,
  Buddy_ID int(11) default NULL,
  Description varchar(35) default NULL,
  Block tinyint(4) default NULL,
  PRIMARY KEY  (Address_ID),
  KEY fi0 (Buddy_ID),
  CONSTRAINT tblbuddylist_ibfk_1 FOREIGN KEY (Buddy_ID) REFERENCES tblauthor (Author_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tblcategory (
  Cat_ID int(11) NOT NULL default '0',
  Cat_name varchar(51) default NULL,
  Cat_order int(11) default NULL,
  PRIMARY KEY  (Cat_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbldatetimeformat (
  Date_format varchar(10) NOT NULL default '',
  Year_format varchar(6) default NULL,
  Seporator varchar(15) default NULL,
  Month1 varchar(15) default NULL,
  Month2 varchar(15) default NULL,
  Month3 varchar(15) default NULL,
  Month4 varchar(15) default NULL,
  Month5 varchar(15) default NULL,
  Month6 varchar(15) default NULL,
  Month7 varchar(15) default NULL,
  Month8 varchar(15) default NULL,
  Month9 varchar(15) default NULL,
  Month10 varchar(15) default NULL,
  Month11 varchar(15) default NULL,
  Month12 varchar(15) default NULL,
  Time_format int(11) default NULL,
  am varchar(6) default NULL,
  pm varchar(6) default NULL,
  PRIMARY KEY  (Date_format)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert  into tbldatetimeformat values
('dd/mm/yy', 'long', '?', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December', 12, 'am', 'pm');

CREATE TABLE tblemailnotify (
  Watch_ID int(11) NOT NULL default '0',
  Author_ID int(11) default NULL,
  Forum_ID int(11) default NULL,
  Topic_ID int(11) default NULL,
  PRIMARY KEY  (Watch_ID),
  KEY fi0 (Autho]]> Mon, 13 Jun 2005 04:54:56 +0000 https://forums.webwiz.net/to-mysql_topic15414_post84993.html#84993 <![CDATA[to MySql : The present version will not work...]]> https://forums.webwiz.net/to-mysql_topic15414_post84879.html#84879 Author: WebWiz-Bruce
Subject: 15414
Posted: 10 June 2005 at 3:43am

The present version will not work with mySQL as mySQL doesn't fullysupport ADO and the SQL used for mySQL is different to that used inAccess or SQL Server]]> Fri, 10 Jun 2005 03:43:34 +0000 https://forums.webwiz.net/to-mysql_topic15414_post84879.html#84879 <![CDATA[to MySql : does anyone havetxt file to createthistables...]]> https://forums.webwiz.net/to-mysql_topic15414_post84875.html#84875 Author: wang
Subject: 15414
Posted: 09 June 2005 at 11:57pm

does anyone have txt file to create this tables in MySql?
 
 
]]> Thu, 09 Jun 2005 23:57:56 +0000 https://forums.webwiz.net/to-mysql_topic15414_post84875.html#84875