MLM - Can't create mySQL database

B

BMcDonald

Member
I'm not having any luck setting up a mySQL database

I just get this error:

ERROR: Impossible to create the database or the table
[: ]

I've also tried creating an empty database and running the init command

Tried doing it with the user I set up in Cpanel and with root user for the whole server. no luck.
 
stanbusk

stanbusk

Administrator
Staff member
That looks correct. Are you sure you are using the right mySQL settings? Right server address, right server name, right user ID and password? It has to be a full access account.
 
B

BMcDonald

Member
I double checked and tried a different set of values and now I'm not getting any error messages, but it's not creating the database either. When I enter the url, it seems to accept it, but nothing happens. Just get a blank page in the browser. Bit of progress. No errors. But no database created either.

I just talked to my server tech guy and he said there was an error log, which I can only see logging in as root.

The error it's giving is:

[08-Apr-2009 12:30:52] PHP Fatal error: Call to undefined function: mysql_set_charset() in /home/kickthem/public_html/mlm/mlm.php on line 1612
 
B

BMcDonald

Member
I added the "@" symbol on line 1612

@mysql_set_charset( "utf8", $mysql_link );

And it gives the same fatal error.
 
stanbusk

stanbusk

Administrator
Staff member
Are you sure it gives the same error, I mean for the same line? Perhaps you have to do the same to next line as well
 
stanbusk

stanbusk

Administrator
Staff member
Ok, so now it doesn't do anything, no error and no database created, right?

This is a clear symptom your access data is wrong. I mean, the account you are using is not a full privileges account. You may write or read but you are not allowed to create databases. I use myself 3 different accounts. One is read only, second is read/write and third has full access. When using the script I have to use the full access account.
 
B

BMcDonald

Member
Can you just send me the sql dump file so I can just upload it manually to create the database. The flat file was working fine, till it wouldn't delete that one email address.
 
stanbusk

stanbusk

Administrator
Staff member
You will find inside the MLM file the description of the table to create. I think it is easy to create it manually.
 
B

BMcDonald

Member
I found it, but it's not in a form that you can just cut and paste into a sql query. It keeps telling me the syntax is not correct.
 
stanbusk

stanbusk

Administrator
Staff member
Try
Code: 
CREATE TABLE `tbl_mlm_sub` (
  `fld_id` bigint(20) NOT NULL auto_increment,
  `fld_list` varchar(64) collate utf8_bin NOT NULL,
  `fld_firstname` varchar(64) collate utf8_bin default NULL,
  `fld_lastname` varchar(64) collate utf8_bin default NULL,
  `fld_company` varchar(64) collate utf8_bin default NULL,
  `fld_email` varchar(64) collate utf8_bin NOT NULL,
  `fld_opt1` varchar(128) collate utf8_bin default NULL,
  `fld_opt2` varchar(128) collate utf8_bin default NULL,
  `fld_opt3` varchar(128) collate utf8_bin default NULL,
  `fld_opt4` varchar(128) collate utf8_bin default NULL,
  `fld_opt5` varchar(128) collate utf8_bin default NULL,
  `fld_opt6` varchar(128) collate utf8_bin default NULL,
  `fld_opt7` varchar(128) collate utf8_bin default NULL,
  `fld_opt8` varchar(128) collate utf8_bin default NULL,
  `fld_opt9` varchar(128) collate utf8_bin default NULL,
  `fld_opt10` varchar(128) collate utf8_bin default NULL,
  `fld_opt11` varchar(128) collate utf8_bin default NULL,
  `fld_opt12` varchar(128) collate utf8_bin default NULL,
  `fld_opt13` varchar(128) collate utf8_bin default NULL,
  `fld_opt14` varchar(128) collate utf8_bin default NULL,
  `fld_opt15` varchar(128) collate utf8_bin default NULL,
  `fld_opt16` varchar(128) collate utf8_bin default NULL,
  `fld_opt17` varchar(128) collate utf8_bin default NULL,
  `fld_opt18` varchar(128) collate utf8_bin default NULL,
  `fld_opt19` varchar(128) collate utf8_bin default NULL,
  `fld_opt20` varchar(128) collate utf8_bin default NULL,
  `fld_sub` tinyint(1) NOT NULL default '1',
  `fld_bl` tinyint(1) NOT NULL default '0',
  `fld_pwd` varchar(64) collate utf8_bin default NULL,
  PRIMARY KEY  (`fld_id`),
  KEY `fld_list` (`fld_list`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INC
 
You must log in or register to reply here.
Top