no topics/posts after conversion; can't enter admin area

[curious]

I finally converted my YaBB Gold to SE 1.1.0.

Conversion went fine, but I'm facing two problems I can't get rid of:

• The threads in the diffrent boards don't show up. The boards are empty.
• I can't access admin section.

For the first problem:
I checked my database and found all topics and messages there.
I'd like to try repair my boards, but ... prob two

Can anybody offer some help?

thx in advance

For problem two:
I get the following error message:

Code Select Expand

2: Supplied argument is not a valid MySQL result resource
(/home/www/web296/html/yabbse/Sources/Admin.php ln 73)
This line in Admin.php says:

Code Select Expand

   $numcats = $temp[0];
   $result = mysql_query("SELECT COUNT(*) as click_total FROM {$db_prefix}log_clicks;");
   $temp = mysql_fetch_row($result);it's the last line

Also I got a single error message in the conversion process which was:

Code Select Expand

Inserting data package 10
Errors: Column 'logTime' is used with UNIQUE or INDEX but is not defined as NOT NULLI'm pretty sure this has to do with problem two.


I was searching the forums for help, but couldn't find any, though I think I have seen these problems mentioned somewhere.
Using the search function is a pain in the ass. No matter which forums you choose or if you choose either subject or message, hits are shown from all forums and subjects as well as messages.

[curious]

Just found this thread:
http://www.yabb.info/community/index.php?board=131;action=display;threadid=4130;start=0

But I don't know how to create the suggested table
I have phpmyadmin.

[Jeff Lewis]

Log into your phpmyadmin and click on your database.  There should be a box that allows you to enter SL commands.  Enter this and press go:

Code Select Expand

CREATE TABLE log_clicks (
  ip tinytext,
  logTime bigint(20) NOT NULL,
  agent tinytext,
  toUrl tinytext,
  fromUrl tinytext,
  PRIMARY KEY  (ID_CLICKS)
) TYPE=MyISAM;

[curious]

Well thanks Jeff, but this is what I get:

Code Select Expand

Error
SQL-query:

CREATE TABLE log_clicks (
  ip tinytext,
  logTime bigint(20) NOT NULL,
  agent tinytext,
  toUrl tinytext,
  fromUrl tinytext,
  PRIMARY KEY  (ID_CLICKS)
) TYPE=MyISAM;
MySQL said: Key column 'ID_CLICKS' doesn't exist in table


[curious]

Ok, problem solved with the help of Jeff *applaude*

Code Select Expand

CREATE TABLE log_clicks (
  ip tinytext,
  logTime bigint(20) NOT NULL,
  agent tinytext,
  toUrl tinytext,
  fromUrl tinytext,
  KEY logTime (logTime)
) TYPE=MyISAM;
After several tries this code finally created the log_clicks table (which was missing in my case) in my database.

Entered admin area, ran "Repair All Boards and Topics" and "Recount All Board Totals" and went happy cause this brought back my topics and posts.