Sorry to ask again...
How can I do to add a go back to ... link next to login.
I know it's in main.tpl
I tried but it does not work. Where do I exactly have to put that link?

Ludo,

377

(2 replies, posted in PunBB 1.2 troubleshooting)

Thanks Paul.
I put text decoration: none in css and it works good wink

Ludo

378

(2 replies, posted in PunBB 1.2 troubleshooting)

Hi,

I'm personalizing punbb 1.2
I do not like the fact that most of links are underlined when they are not hoovered.
I looked for in .css and _cs.css and base.css but I did not find.
Can you tell me where it is?

Ludo,

Rickard wrote:

UPDATE users SET language='French'

It also works for me. Thanks Ricard!

Ludo,

Maybe the choice of the language could be made in the update script?
I mean for example, when a forum is in french, we could directly choose that all users would be in french. And if some users want another language, they could change it in their profile.

Ludo,

Hi,

After updating, every users are in english.
When you have many users, it's anoying to change their profile one by one to French for my example.
Can it be done by a sql query? If yes which?

Ludo,

Thank you Rickard. This has fixed the problem. smile

Ludo,

1.2 installed with difficulties.
When I try to change something in my profile, I have the following error:
"Bad request. The link you followed is incorrect or outdated."
What's that?
If you want, you can go here http://www.oyre.net/forum to try
My base forum is "http://www.oyre.net/forum" in options.

Ludo

384

(26 replies, posted in PunBB 1.2 bug reports)

Thanks Rickard.
We'll se that later, there is no problem.
While waiting, I'll try to skin 1.2, which does not seem easy to do.
Give me a sign when you're not too busy

Ludo,

385

(26 replies, posted in PunBB 1.2 bug reports)

no help?

So, more simply, is it possible to convert 1.1.5 (missing _idx) to 1.2?
Are missing indexes so important? Why can 1.1.5 work without this indexes? Can 1.2?

Ludo,

386

(15 replies, posted in Archive)

par exemple, mon forum http://www.pluriservices.net/forum prend environ 600 à 700 ko dans ma base de donnée.

cordialement,

387

(26 replies, posted in PunBB 1.2 bug reports)

Rickard wrote:

Very odd. When you install PunBB 1.1.5, does the install finish without any errors?

Yes. I haven't got any errors on the first DB.

I was thinking about the problem this night and about what you told me. You said phpmyadmin was a very old version on the first DB I gave you access.
I replied you that the problem was the same on a recent version of phpmyadmin on the second DB I gave you access.
I've forgotten to tell you that punbb 1.1.5 which works on the second DB was originally installed on an old version and then migrated on a recent version of phpmyadmin.
I hope you understand what I mean. I mean that the problem may have something to do with the old version.
To be sure, I installed 1.1.5 on the second DB (which has a recent version of phpmyadmin). I try to update it. I had another problem:

An error was encountered
File: /home/ju37853/pun/update.php
Line: 224
PunBB reported: Unable to add group 
Database reported: Table 'ju37853.puntestgroups' doesn't exist (Errno: 1146)

Any idea?

thanksfully,

Ludo

388

(4 replies, posted in PunBB 1.2 bug reports)

I've had the same problem
GO to your DB
On the table user, you have guest. Change the style and put manually for example cobalt.

Ludo,

389

(26 replies, posted in PunBB 1.2 bug reports)

Rickard wrote:

Just for fun, install a fresh 1.1.5 install, save a structure dump of it and then try to upgrade it to 1.2. If it fails, post the structure dump here.

Ok Rickard,

Just for fun as you say (even if it does not make me laugh sad) I've installed 1.1.5 on two different webhosters.
Then, I tried to update to 1.2.
Guess! I've got exactly the same problem:

File: /home/oyre/www/pun/update.php
Line: 166
PunBB reported: Unable to alter DB structure. 
Database reported: Can't DROP 'puntestsearch_results_ident_idx'. Check that column/key exists (Errno: 1091)

I'm really sad not to be able to update the 1.2 I've waited for so long time.

As you asked me, this is the dump before updating.

Have you got an idea?

# Structure de la table 'puntestbans'
#

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


# --------------------------------------------------------
#
# Structure de la table 'puntestcategories'
#

CREATE TABLE puntestcategories (
   id int(10) unsigned NOT NULL auto_increment,
   cat_name varchar(80) DEFAULT 'New Category' NOT NULL,
   disp_position int(10) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestcensoring'
#

CREATE TABLE puntestcensoring (
   id int(10) unsigned NOT NULL auto_increment,
   search_for varchar(60) NOT NULL,
   replace_with varchar(60) NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestconfig'
#

CREATE TABLE puntestconfig (
   conf_name varchar(255) NOT NULL,
   conf_value text,
   PRIMARY KEY (conf_name)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestforums'
#

CREATE TABLE puntestforums (
   id int(10) unsigned NOT NULL auto_increment,
   forum_name varchar(80) DEFAULT 'New forum' NOT NULL,
   forum_desc text,
   moderators text,
   num_topics mediumint(8) unsigned DEFAULT '0' NOT NULL,
   num_posts mediumint(8) unsigned DEFAULT '0' NOT NULL,
   last_post int(10) unsigned,
   last_post_id int(10) unsigned,
   last_poster varchar(200),
   closed tinyint(1) DEFAULT '0' NOT NULL,
   admmod_only tinyint(1) DEFAULT '0' NOT NULL,
   disp_position int(10) DEFAULT '0' NOT NULL,
   cat_id int(10) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestonline'
#

CREATE TABLE puntestonline (
   user_id int(10) unsigned DEFAULT '0' NOT NULL,
   ident varchar(200) NOT NULL,
   logged int(10) unsigned DEFAULT '0' NOT NULL
);


# --------------------------------------------------------
#
# Structure de la table 'puntestposts'
#

CREATE TABLE puntestposts (
   id int(10) unsigned NOT NULL auto_increment,
   poster varchar(200) NOT NULL,
   poster_id int(10) unsigned DEFAULT '1' NOT NULL,
   poster_ip varchar(15),
   poster_email varchar(50),
   message text NOT NULL,
   smilies tinyint(1) DEFAULT '1' NOT NULL,
   posted int(10) unsigned DEFAULT '0' NOT NULL,
   edited int(10) unsigned,
   edited_by varchar(200),
   topic_id int(10) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestranks'
#

CREATE TABLE puntestranks (
   id int(10) unsigned NOT NULL auto_increment,
   rank varchar(50) NOT NULL,
   min_posts mediumint(8) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestreports'
#

CREATE TABLE puntestreports (
   id int(10) unsigned NOT NULL auto_increment,
   post_id int(10) unsigned DEFAULT '0' NOT NULL,
   topic_id int(10) unsigned DEFAULT '0' NOT NULL,
   forum_id int(10) unsigned DEFAULT '0' NOT NULL,
   reported_by int(10) unsigned DEFAULT '0' NOT NULL,
   created int(10) unsigned DEFAULT '0' NOT NULL,
   message text NOT NULL,
   zapped int(10) unsigned,
   zapped_by int(10) unsigned,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestsearch_matches'
#

CREATE TABLE puntestsearch_matches (
   post_id int(10) unsigned DEFAULT '0' NOT NULL,
   word_id int(10) unsigned DEFAULT '0' NOT NULL,
   subject_match tinyint(1) DEFAULT '0' NOT NULL
);


# --------------------------------------------------------
#
# Structure de la table 'puntestsearch_results'
#

CREATE TABLE puntestsearch_results (
   id int(10) unsigned DEFAULT '0' NOT NULL,
   ident varchar(200) NOT NULL,
   search_data text NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestsearch_words'
#

CREATE TABLE puntestsearch_words (
   id int(10) unsigned NOT NULL auto_increment,
   word varchar(20) binary NOT NULL,
   PRIMARY KEY (word),
   KEY puntestsearch_words_id_idx (id)
);


# --------------------------------------------------------
#
# Structure de la table 'puntestsubscriptions'
#

CREATE TABLE puntestsubscriptions (
   user_id int(10) unsigned DEFAULT '0' NOT NULL,
   topic_id int(10) unsigned DEFAULT '0' NOT NULL
);


# --------------------------------------------------------
#
# Structure de la table 'puntesttopics'
#

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


# --------------------------------------------------------
#
# Structure de la table 'puntestusers'
#

CREATE TABLE puntestusers (
   id int(10) unsigned NOT NULL auto_increment,
   username varchar(200) NOT NULL,
   password varchar(40) NOT NULL,
   email varchar(50) NOT NULL,
   title varchar(50),
   realname varchar(40),
   url varchar(100),
   icq varchar(12),
   msn varchar(50),
   aim varchar(20),
   yahoo varchar(20),
   location varchar(30),
   use_avatar tinyint(1) DEFAULT '0' NOT NULL,
   signature text,
   disp_topics tinyint(3) unsigned,
   disp_posts tinyint(3) unsigned,
   email_setting tinyint(1) DEFAULT '1' NOT NULL,
   save_pass tinyint(1) DEFAULT '1' NOT NULL,
   notify_with_post tinyint(1) DEFAULT '0' NOT NULL,
   smilies tinyint(1) DEFAULT '1' NOT NULL,
   show_img tinyint(1) DEFAULT '1' NOT NULL,
   show_avatars tinyint(1) DEFAULT '1' NOT NULL,
   show_sig tinyint(1) DEFAULT '1' NOT NULL,
   link_to_new_win tinyint(1) DEFAULT '1' NOT NULL,
   timezone tinyint(2) DEFAULT '0' NOT NULL,
   style varchar(25) DEFAULT 'Oxygen' NOT NULL,
   num_posts int(10) unsigned DEFAULT '0' NOT NULL,
   status tinyint(1) DEFAULT '-1' NOT NULL,
   last_post int(10) unsigned,
   registered int(10) unsigned DEFAULT '0' NOT NULL,
   last_visit int(10) unsigned DEFAULT '0' NOT NULL,
   last_action int(10) unsigned DEFAULT '0' NOT NULL,
   admin_note varchar(30),
   activate_string varchar(50),
   activate_key varchar(8),
   PRIMARY KEY (id)
);

390

(26 replies, posted in PunBB 1.2 bug reports)

I've never installed any mode.
The only modification I made were to personalise header and footer

391

(26 replies, posted in PunBB 1.2 bug reports)

they are fresh installed. They were installed in 1.1.4 and upgraded to 1.1.5

392

(3 replies, posted in PunBB 1.2 bug reports)

Just to say that there is a \ missing in french pack in prof_reg
For 'E-mail setting info' before the '
you must have (formulaire d\'e-mail) instead of (formulaire d'e-mail)

It gave an error for me...

wink

Ludo,

393

(26 replies, posted in PunBB 1.2 bug reports)

I've got 3 forums using punbb 1.1.5
For every forums it's the same problem.
Was there a problem with the installation of 1.1.5
I really don't understand.

394

(26 replies, posted in PunBB 1.2 bug reports)

the forum worked good without theses missing indexes in 1.1.5

395

(26 replies, posted in PunBB 1.2 bug reports)

I've understood what you want.
So this is the structure of the db before upgrading:

Structure de la table `forumbans`
-- 

CREATE TABLE `forumbans` (
  `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 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcategories`
-- 

CREATE TABLE `forumcategories` (
  `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 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumcensoring`
-- 

CREATE TABLE `forumcensoring` (
  `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 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumconfig`
-- 

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

-- --------------------------------------------------------

-- 
-- Structure de la table `forumforums`
-- 

CREATE TABLE `forumforums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `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,
  `closed` tinyint(1) NOT NULL default '0',
  `admmod_only` 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 AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumonline`
-- 

CREATE TABLE `forumonline` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumposts`
-- 

CREATE TABLE `forumposts` (
  `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,
  `smilies` tinyint(1) NOT NULL default '1',
  `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`)
) TYPE=MyISAM AUTO_INCREMENT=1062 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumranks`
-- 

CREATE TABLE `forumranks` (
  `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 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumreports`
-- 

CREATE TABLE `forumreports` (
  `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`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_matches`
-- 

CREATE TABLE `forumsearch_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` int(10) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_results`
-- 

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

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsearch_words`
-- 

CREATE TABLE `forumsearch_words` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `forumsearch_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7158 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumsubscriptions`
-- 

CREATE TABLE `forumsubscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumtopics`
-- 

CREATE TABLE `forumtopics` (
  `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`)
) TYPE=MyISAM AUTO_INCREMENT=151 ;

-- --------------------------------------------------------

-- 
-- Structure de la table `forumusers`
-- 

CREATE TABLE `forumusers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `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,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(20) default NULL,
  `yahoo` varchar(20) 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',
  `smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `link_to_new_win` tinyint(1) NOT NULL default '1',
  `timezone` tinyint(2) NOT NULL default '0',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '-1',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `last_action` 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`)
) TYPE=MyISAM AUTO_INCREMENT=141 ;

It has no link but I also want to tell you that though I'm subscribed to this topic, I do not receive any notification when an answer is posted.

Ludo

396

(26 replies, posted in PunBB 1.2 bug reports)

I also want to explain that:

I've got several forums using punbb.

I haven't got any dump for the first I tried to upgraded and which doesn't work at the moment. (http://www.oyre.net/forum)

I Try to upgrade the second and I have exactly the same error. But I obviously got a dump for this second. Do you want the dump before I started to upgrade or after I started upgrading? at which mail adress can I send you the dump?

Ludo,

397

(26 replies, posted in PunBB 1.2 bug reports)

no problem.
Can I send you by mail the former dump I got? It's about 3 Mo

Ludo,

398

(26 replies, posted in PunBB 1.2 bug reports)

I deleted DROP 'forumsearch_results_ident_idx' from the update script.
But i got another problem:
Can't DROP 'forumsubscriptions_user_id_idx'. Check that column/key exists (Errno: 1091)

I also deleted this line. The update is made but see what I got. The problem comes from every idx files.
It's a very light punbb...

http://www.oyre.net/forum

what's up?

Ludo,

399

(26 replies, posted in PunBB 1.2 bug reports)

I do not have any search_results table as the update script has begun to execute. It has certainly erased the search_results table.
I also tell you that I have no dump of my DB. I assume it.
So, I can't answer your question.

Ludo,

400

(26 replies, posted in PunBB 1.2 bug reports)

Hi,

I've got a problem
When i try to update, i've got the following message:
File: /home/oyre/www/forum/update.php
Line: 166

PunBB reported: Unable to alter DB structure.

Database reported: Can't DROP 'forumsearch_results_ident_idx'. Check that column/key exists (Errno: 1091)

Help me please.

Ludo,