1 Topic by punkrider (edited by punkrider 2005-01-29 01:14)

  • Registered: 2005-01-29
  • Posts: 7

Topic: upgrade error

I thought I followed the instructions for upgrading from 1.1.5 to 1.2 and after running the upgrade script which said it was successful  I get this now:

Notice: Undefined index: g_id in /home/myfam/www/talk/include/functions.php on line 150

Notice: Undefined index: g_read_board in /home/myfam/www/talk/index.php on line 30

Notice: Undefined index: g_search in /home/myfam/www/talk/include/functions.php on line 240
An error was encountered
File: /home/myfam/www/talk/index.php
Line: 42

PunBB reported: Unable to fetch category/forum list

Database reported: 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 ') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.dis (Errno: 1064)

any ideas why?

thanks!

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: upgrade error

And the upgrade script finished without problems?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

yes

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: upgrade error

Could you export the table structure of your forum database and paste it here?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

Thanks a lot.  I appreciate the help.  PunBB is the best of them all!

#
# Table structure for table `bans`
#

CREATE TABLE bans (
  id int(10) unsigned NOT NULL auto_increment,
  username varchar(200) default NULL,
  ip varchar(255) default NULL,
  email varchar(50) default NULL,
  message varchar(255) default NULL,
  expire int(10) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE categories (
  id int(10) unsigned NOT NULL auto_increment,
  cat_name varchar(80) NOT NULL default 'New Category',
  disp_position int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `censoring`
#

CREATE TABLE censoring (
  id int(10) unsigned NOT NULL auto_increment,
  search_for varchar(60) NOT NULL default '',
  replace_with varchar(60) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `config`
#

CREATE TABLE config (
  conf_name varchar(255) NOT NULL default '',
  conf_value text,
  PRIMARY KEY  (conf_name)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `forum_perms`
#

CREATE TABLE forum_perms (
  group_id int(10) NOT NULL default '0',
  forum_id int(10) NOT NULL default '0',
  read_forum tinyint(1) NOT NULL default '1',
  post_replies tinyint(1) NOT NULL default '1',
  post_topics tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (group_id,forum_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `forums`
#

CREATE TABLE forums (
  id int(10) unsigned NOT NULL auto_increment,
  forum_name varchar(80) NOT NULL default 'New forum',
  forum_desc text,
  redirect_url varchar(100) default NULL,
  moderators text,
  num_topics mediumint(8) unsigned NOT NULL default '0',
  num_posts mediumint(8) unsigned NOT NULL default '0',
  last_post int(10) unsigned default NULL,
  last_post_id int(10) unsigned default NULL,
  last_poster varchar(200) default NULL,
  sort_by tinyint(1) NOT NULL default '0',
  disp_position int(10) NOT NULL default '0',
  cat_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `groups`
#

CREATE TABLE groups (
  g_id int(10) unsigned NOT NULL auto_increment,
  g_title varchar(50) NOT NULL default '',
  g_user_title varchar(50) default NULL,
  g_read_board tinyint(1) NOT NULL default '1',
  g_post_replies tinyint(1) NOT NULL default '1',
  g_post_topics tinyint(1) NOT NULL default '1',
  g_post_polls tinyint(1) NOT NULL default '1',
  g_edit_posts tinyint(1) NOT NULL default '1',
  g_delete_posts tinyint(1) NOT NULL default '1',
  g_delete_topics tinyint(1) NOT NULL default '1',
  g_set_title tinyint(1) NOT NULL default '1',
  g_search tinyint(1) NOT NULL default '1',
  g_search_users tinyint(1) NOT NULL default '1',
  g_edit_subjects_interval smallint(6) NOT NULL default '300',
  g_post_flood smallint(6) NOT NULL default '30',
  g_search_flood smallint(6) NOT NULL default '30',
  PRIMARY KEY  (g_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `online`
#

CREATE TABLE online (
  user_id int(10) unsigned NOT NULL default '0',
  ident varchar(200) NOT NULL default '',
  logged int(10) unsigned NOT NULL default '0',
  idle tinyint(1) NOT NULL default '0',
  KEY online_user_id_idx (user_id)
) TYPE=HEAP;

# --------------------------------------------------------

#
# Table structure for table `posts`
#

CREATE TABLE posts (
  id int(10) unsigned NOT NULL auto_increment,
  poster varchar(200) NOT NULL default '',
  poster_id int(10) unsigned NOT NULL default '1',
  poster_ip varchar(15) default NULL,
  poster_email varchar(50) default NULL,
  message text NOT NULL,
  hide_smilies tinyint(1) NOT NULL default '0',
  posted int(10) unsigned NOT NULL default '0',
  edited int(10) unsigned default NULL,
  edited_by varchar(200) default NULL,
  topic_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY posts_topic_id_idx (topic_id),
  KEY posts_multi_idx (poster_id,topic_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `ranks`
#

CREATE TABLE ranks (
  id int(10) unsigned NOT NULL auto_increment,
  rank varchar(50) NOT NULL default '',
  min_posts mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `reports`
#

CREATE TABLE reports (
  id int(10) unsigned NOT NULL auto_increment,
  post_id int(10) unsigned NOT NULL default '0',
  topic_id int(10) unsigned NOT NULL default '0',
  forum_id int(10) unsigned NOT NULL default '0',
  reported_by int(10) unsigned NOT NULL default '0',
  created int(10) unsigned NOT NULL default '0',
  message text NOT NULL,
  zapped int(10) unsigned default NULL,
  zapped_by int(10) unsigned default NULL,
  PRIMARY KEY  (id),
  KEY reports_zapped_idx (zapped)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `search_cache`
#

CREATE TABLE search_cache (
  id int(10) unsigned NOT NULL default '0',
  ident varchar(200) NOT NULL default '',
  search_data text NOT NULL,
  PRIMARY KEY  (id),
  KEY search_cache_ident_idx (ident(8))
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `search_matches`
#

CREATE TABLE search_matches (
  post_id int(10) unsigned NOT NULL default '0',
  word_id mediumint(8) unsigned NOT NULL default '0',
  subject_match tinyint(1) NOT NULL default '0',
  KEY search_matches_word_id_idx (word_id),
  KEY search_matches_post_id_idx (post_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `search_words`
#

CREATE TABLE search_words (
  id mediumint(8) unsigned NOT NULL auto_increment,
  word varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (word),
  KEY search_words_id_idx (id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `subscriptions`
#

CREATE TABLE subscriptions (
  user_id int(10) unsigned NOT NULL default '0',
  topic_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,topic_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `topics`
#

CREATE TABLE topics (
  id int(10) unsigned NOT NULL auto_increment,
  poster varchar(200) NOT NULL default '',
  subject varchar(255) NOT NULL default '',
  posted int(10) unsigned NOT NULL default '0',
  last_post int(10) unsigned NOT NULL default '0',
  last_post_id int(10) unsigned NOT NULL default '0',
  last_poster varchar(200) default NULL,
  num_views mediumint(8) unsigned NOT NULL default '0',
  num_replies mediumint(8) unsigned NOT NULL default '0',
  closed tinyint(1) NOT NULL default '0',
  sticky tinyint(1) NOT NULL default '0',
  moved_to int(10) unsigned default NULL,
  forum_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY topics_forum_id_idx (forum_id),
  KEY topics_moved_to_idx (moved_to)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE users (
  id int(10) unsigned NOT NULL auto_increment,
  group_id int(10) NOT NULL default '4',
  username varchar(200) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  title varchar(50) default NULL,
  realname varchar(40) default NULL,
  url varchar(100) default NULL,
  jabber varchar(75) default NULL,
  icq varchar(12) default NULL,
  msn varchar(50) default NULL,
  aim varchar(30) default NULL,
  yahoo varchar(30) default NULL,
  location varchar(30) default NULL,
  use_avatar tinyint(1) NOT NULL default '0',
  signature text,
  disp_topics tinyint(3) unsigned default NULL,
  disp_posts tinyint(3) unsigned default NULL,
  email_setting tinyint(1) NOT NULL default '1',
  save_pass tinyint(1) NOT NULL default '1',
  notify_with_post tinyint(1) NOT NULL default '0',
  show_smilies tinyint(1) NOT NULL default '1',
  show_img tinyint(1) NOT NULL default '1',
  show_img_sig tinyint(1) NOT NULL default '1',
  show_avatars tinyint(1) NOT NULL default '1',
  show_sig tinyint(1) NOT NULL default '1',
  timezone float NOT NULL default '0',
  language varchar(25) NOT NULL default 'English',
  style varchar(25) NOT NULL default 'Oxygen',
  num_posts int(10) unsigned NOT NULL default '0',
  last_post int(10) unsigned default NULL,
  registered int(10) unsigned NOT NULL default '0',
  registration_ip varchar(15) NOT NULL default '0.0.0.0',
  last_visit int(10) unsigned NOT NULL default '0',
  admin_note varchar(30) default NULL,
  activate_string varchar(50) default NULL,
  activate_key varchar(8) default NULL,
  PRIMARY KEY  (id),
  KEY users_registered_idx (registered),
  KEY users_username_idx (username(3))
) TYPE=MyISAM;

6 Reply by punkrider (edited by punkrider 2005-01-31 18:12)

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

one thing i do remember about the 1.1.5 install that was there previously.  Before I upgraded I was noticing some wierd occurrances of the characters #1 being appended to one username in the forum display.  Also, PunBB would say there was a last post by one user, but then the post would never appear there.  Could the database have been corrupted before that and caused this?  Thx again.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: upgrade error

Your dump looks just fine. It must be a problem with the contents of the tables then. Have you converted from a different board earlier?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

No.  That was the first install of PunBB i have ever had.  There were only about 15 messages on the board when I upgraded, so I'm sure I can sort it out if it is indeed a content issue.  I did reset all  user.style records to 'Oxygen' but this didn't help.  I'll purge the contents of the db and re-add each record to see if I can find the culprit for you.

Cheers, and thanks again.

-j

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: upgrade error

Check one thing. Make sure the user with id = 1 has group_id set to 3.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

and if there isn't a user with id = 1 ?  ;-) 

would that be a problem?  I do still have Guest and admin as id = 3 and 4 respectively

  • Registered: 2005-01-29
  • Posts: 7

Re: upgrade error

I added a default test user with and ID of 1 and it all works now!  smile  yay.  Thanks for the expertise.  What does the user with id = 1 do for the system?  Is this an account that I should have working for me, or can i just leave a dummy user here?

-j

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: upgrade error

LMAO
Guest should be 1 tongue