Step 7 -- Error -- missing table?

[rblissett]

Hi All,

Below is the error I recieved. Unfortunately I'm not that familiar with mySQL. Other than the fact I know my account comes with it. I was able to look at the database and could see all the other table names but for some unknown reason it looks like it didn't create this one. I re-ran the installer and still got stuck here.

Error: Table 'local1db.yabbse_members' doesn't exist

I did try and create a table on my own but wasn't sure what the different settings would be, so I left it hoping someone here could offer some help.

Thanks in advance,

Rob

[TheJkWhoSaysNi]

You say you can view your database? then you probably have phpmyadmin
if you do:
click on the database name in the top-left of the page.

then you should see a text box that says
"Run SQL query/queries on database ***" above it

copy this:

Code Select Expand

CREATE TABLE yabbse_members (
  ID_MEMBER int(10) unsigned NOT NULL auto_increment,
  memberName tinytext NOT NULL,
  realName tinytext,
  passwd tinytext NOT NULL,
  emailAddress tinytext,
  dateRegistered bigint(20) default NULL,
  personalText tinytext,
  memberGroup tinytext,
  gender tinytext,
  birthdate date NOT NULL default '0000-00-00',
  websiteTitle tinytext,
  websiteUrl tinytext,
  location tinytext,
  ICQ tinytext,
  AIM tinytext,
  YIM tinytext,
  hideEmail tinyint(4) default NULL,
  timeFormat tinytext,
  signature text,
  posts int(11) default NULL,
  timeOffset float default NULL,
  avatar tinytext,
  im_ignore_list text,
  im_email_notify tinyint(4) NOT NULL default '0',
  karmaGood int(11) NOT NULL default '0',
  karmaBad int(11) NOT NULL default '0',
  lastLogin bigint(20) default NULL,
  PRIMARY KEY  (ID_MEMBER),
  UNIQUE KEY memberID (ID_MEMBER),
  KEY memberID_2 (ID_MEMBER)
) TYPE=MyISAM;
(After it says CREATE TABLE you may need to change the yabbse_ part if you used a different prefix)
into that box and press go, there, table created

are you missing any other tables?

there should be 20 YaBB SE tables in 1.0.0 (It may be different with 1.1.0 i'm not sure)
Hope that works

I have no idea why it was not created, strange, oh well...

[rblissett]

Thanks for the quick feedback. But as far as having up to 20 tables, nope. Below is a cut & paste of what I have:

Database local1db

yabbse_banned
yabbse_censor  
yabbse_log_banned
yabbse_log_floodcontrol
yabbse_log_online
yabbse_reserved_names
yabbse_settings

Now oddly enough I created a phpinfo file @ http://www.labattworkers.com/cgi-bin/yabbse/phpinfo.php and got some type of security error that the host is looking into. Yet I know PHP must be working to some degree as it had to to even run the install script. That is probably a separate issue but I thought it was worth mentioning. BTW: is the phpinfo script suppose to be CHMOD'd in any special way?

Thanks,

Rob

[TheJkWhoSaysNi]

ouch, these are the table I have (and i guess you're supposed to have)

  yabbse_banned
  yabbse_boards
  yabbse_categories
  yabbse_censor
  yabbse_instant_messages
  yabbse_log_banned
  yabbse_log_boards
  yabbse_log_clicks
  yabbse_log_floodcontrol
  yabbse_log_karma
  yabbse_log_mark_read
  yabbse_log_online
  yabbse_log_topics
  yabbse_membergroups
  yabbse_members
  yabbse_messages
  yabbse_polls
  yabbse_reserved_names
  yabbse_settings
  yabbse_topics

If i were you i'd delete the ones that you have and run the installer again.

[rblissett]

So anyway... I do have phpmyadmin and did execute the script provided. Then reran the install.php. I got the installation successful message. However, when you go to the site it looks pretty horrible, even the colours are brutal. I'm upgrading from SP1 and was totally impressed by even the default screen, I installed that board with absolutley no issues  

Would you or anyone else following this thread mind taking a look and tell me if you could make sense of this. Your help with this is much appreciated.

And if anyone is familiar with hypermart.net, that is who I'm hosting with. Maybe there are issues with them or their settings. I don't know, just thought I'd throw that out there also.

Thanks,

Rob

http://www.labattworkers.com/cgi-bin/yabbse/index.php

Sorry, just one other thought, I uploaded all my PHP stuff in binary, I understood that this was fine. Just wanted to make sure.

[Daniel D.]

The converter was written to convert a YaBB Gold board not a SP1 board or do I misunderstood something ...

[rblissett]

OK, now I just tried installing in non-safe mode. The installer indicated that I am in non-safe mode. So I thought :: phew :: that was the problem all along. So I plodded along until step 4 gave me all this junk below:

Inserting data package 1
Errors: Table 'yabbse_banned' already exists

Inserting data package 2
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_BOARD tinyint(4) NOT NULL auto_increment, name tinytext NOT NULL' at line 1

Inserting data package 3
Errors: You have an error in your SQL syntax near '\\\'General Discussion\\\', \\\'Feel free to talk about anything and everything ' at line 1

Inserting data package 4
Errors: You have an error in your SQL syntax near '\\\'0\\\', PRIMARY KEY (ID_CAT)) TYPE=MyISAM' at line 1

Inserting data package 5
Errors: You have an error in your SQL syntax near '\\\'General Category\\\', \\\'\\\', 0)' at line 1

Inserting data package 6
Errors: Table 'yabbse_censor' already exists

Inserting data package 7
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_MEMBER_TO int(11) NOT NULL default \\\'0\\\', deletedBy int(11) ' at line 1

Inserting data package 8
Errors: Table 'yabbse_log_banned' already exists

Inserting data package 9
Errors: You have an error in your SQL syntax near '\\\'0\\\', logTime bigint(20) default NULL) TYPE=MyISAM' at line 1

Inserting data package 10
Errors: You have an error in your SQL syntax near '\\\'0\\\', agent tinytext, toUrl tinytext, fromUrl tinytext, KEY logTime (lo' at line 1

Inserting data package 11
Errors: Table 'yabbse_log_floodcontrol' already exists

Inserting data package 12
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_EXECUTOR int(11) NOT NULL default \\\'0\\\', action tinytext NOT' at line 1

Inserting data package 13
Errors: You have an error in your SQL syntax near '\\\'0\\\', logTime bigint(20) default NULL) TYPE=MyISAM' at line 1

Inserting data package 14
Errors: Table 'yabbse_log_online' already exists

Inserting data package 15
Errors: You have an error in your SQL syntax near '\\\'0\\\', logTime bigint(20) default NULL) TYPE=MyISAM' at line 1

Inserting data package 16
Errors: You have an error in your SQL syntax near '\\\'0\\\', PRIMARY KEY (ID_GROUP)) TYPE=MyISAM' at line 1

Inserting data package 17
Errors: You have an error in your SQL syntax near '\\\'Administrator\\\', 0)' at line 1

etc.....etc.....etc....

Inserting data package 70
Errors: You have an error in your SQL syntax near '\\\'0\\\', ID_MEMBER_STARTED int(11) NOT NULL default \\\'0\\\', ID_MEMBER_UPD' at line 1

I thought that was kinda ugly, but decided to continue on. When I got to step 8 this is what I got:

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/yabbse/Settings.php on line 33

Parse error: parse error in /home/yabbse/Settings.php on line 43


I made sure I CHMOD'd all 3 files just to make sure that wasn't the problem. Any ideas?

Currently I don't care about converting a Yabb Gold board or SP1 board. Frankly I wish I was even at that step  

Thanks,

Rob

[rblissett]

I should add that I checked my versions:

PHP ver. 4.1.2
MySQL ver. 3.23.44

So I think I'm up to date, but I'm definetly getting frustrated. The problem is I don't know what to look for since I don't understand the error messages.

[Jeff Lewis]

All the links you've posted so far give me 404 errors.  A phpinfo file would be very good

[rblissett]

hypermart won't let me run phpinfo for "security reasons". which leads me to wonder if they have other restrictions which is preventing the script from executing properly.

If you've gotten 404 errors it's because I've deleted and tryed reinstalling a couple of times, and done other things as suggested by one of the other members. This is becoming more than frustrating  .

Unless anyone has other suggestions I'm going to try and contact the webhost (hypermart.net) and see how far I get.

Thanks,

Rob

[Jeff Lewis]

Ugh, Hypermart...I think they have an older version of PHP as well.  They also have magic quotes off as well which would explain those errors.

[rblissett]

so are you thinking magic quotes on might just fix this whole problem? Is it that simple

I appreciate your feedback,

Rob

[rblissett]

Hypermart tells me I can turn magic quotes on myself, and even gave me the command to do it. However they tell me magic quotes is turned on by default. Either way I tryed to install this into the install.php code:

<?php
magic_quotes_runtime(1);
}
elseif($step==3)
{
   $installdir = ".";
   $goon = 1;
   $settingsArray = file("$installdir/Settings.php");
   for ($i = 0; $i< sizeof($settingsArray); $i++)
      $settingsArray[$i]=trim($settingsArray[$i]);

   // create a unique encryption key
   $key = md5(uniqid(microtime(),1));
   
   if (!isset($dbprefix)){ $dbprefix = ""; }
   $settingsArray[59] = "\$db_name = \"$dbname\";"; etc................

Of course there is more to that section (step 3) of code but I'm just giving you an example of where I put it, since after executing this part of the installation is when I seem to get all the errors as listing in my previous post.

It looks like I meet all the other requirements for this BB. PHP version 4.1.2 mySQL ver 3.23.44.

Any other thoughts, maybe I need to add the magic quotes line somewhere else? I'm really starting to pull my hair out know. Unfortunately I had the cgi based board running the very first try, so when I decided to upgrade I didn't give it a second thought. In hindsight I should have researched this site to see what hosts people were using and how easy they got it to install the first time. Argh!  

I guess if I could make sense of the error messages than I would be one step closer. Jeff seems to think that magic quotes are off. Hypermart tells me they're on. This sucks!

Help..........

Rob

btw: I still get the same errors after putting in the line --  magic_quotes_runtime(1);

[rblissett]

Here's a side note. A just deleted everything after noticing a newer version of yabbse (1.3), I downloaded it and got the exact same errors as posted above.

However this time I decided to run the index file and see for yourself the errors that popped up.

http://www.labattworkers.com/yabbse/index.php

I don't know if these are related errors or not?

Anyway, I've fired off my 11th email to hypermart. This time I told them to just send me a copy of the php.ini file. After reading other posts, I'm assuming this is where all the core information is. As I stated above I can't run phpinfo, they have it disabled.

[Jeff Lewis]

Try adding this to the top of index.php:

ini_set("allow_call_time_pass_reference", 1);

et me know how that works...