1 Reply by Katryne

(115 replies, posted in Supported extensions)

Thank you Visman, you are a wise man !
I will test and tell you.

Just a word about Github : : I hate it.
I have always had an account there, but I am no geek. I can never find the simple zip file. I can view the detail of a file, the changelog, I can post my comments or my forks. But I cannot simply download a zip file. Last week, to get a new file, I had to build it : copy the content of the file, paste it in a blank page on notepad++ and finally save it under the correct name after having checked the encoding. We are simple users, we need a simple use. Why not a simple zip file to download on this forum ?

That's why I chose to download your extensions pack. Even if I did not nee its whole content.

Go to forum: Supported extensions

2 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Many many Thanks.
I will now try this corrected file on my main (living) forum.

Go to forum: PunBB 1.4 bug reports

3 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Welll thank you... I was able to install Pan antispam. And to register as a new member.
What should I do now ?
Do you have an explanation ?

Go to forum: PunBB 1.4 bug reports

4 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Hello Visman ! Sorry for being so long to answer. And many thanks for your help.
I did as you told me.
But for the last modification I found 2 possible locations and did not know which to modify. So I modify one at randow. And then launched extension install once more.. Below is what is displayed when I was not able to complete the install.

string(6) "errors"
string(335) "CREATE TABLE dbtonline (
user_id INTEGER NOT NULL DEFAULT 1,
ident VARCHAR(200) NOT NULL DEFAULT '',
logged INTEGER NOT NULL DEFAULT 0,
idle INTEGER NOT NULL DEFAULT 0,
csrf_token VARCHAR(40) NOT NULL DEFAULT '',
prev_url VARCHAR(255),
last_post INTEGER,
last_search INTEGER, errors INTEGER NOT NULL DEFAULT 0,
UNIQUE (user_id,ident)
)"

string(6) "errors"
string(335) "CREATE TABLE dbtonline (
user_id INTEGER NOT NULL DEFAULT 1,
ident VARCHAR(200) NOT NULL DEFAULT '',
logged INTEGER NOT NULL DEFAULT 0,
idle INTEGER NOT NULL DEFAULT 0,
csrf_token VARCHAR(40) NOT NULL DEFAULT '',
prev_url VARCHAR(255),
last_post INTEGER,
last_search INTEGER, errors INTEGER NOT NULL DEFAULT 0,
UNIQUE (user_id,ident)
)"

array(8) {
  ["user_id"]=>
  string(27) "INTEGER NOT NULL DEFAULT 1,"
  ["ident"]=>
  string(33) "VARCHAR(200) NOT NULL DEFAULT '',"
  ["logged"]=>
  string(27) "INTEGER NOT NULL DEFAULT 0,"
  ["idle"]=>
  string(27) "INTEGER NOT NULL DEFAULT 0,"
  ["csrf_token"]=>
  string(32) "VARCHAR(40) NOT NULL DEFAULT '',"
  ["prev_url"]=>
  string(13) "VARCHAR(255),"
  ["last_post"]=>
  string(8) "INTEGER,"
  ["last_search"]=>
  string(43) "INTEGER, errors INTEGER NOT NULL DEFAULT 0,"
}

int(0)
string(27) "INTEGER NOT NULL DEFAULT 0,"
string(6) "errors"
array(9) {
  ["errors"]=>
  string(27) "INTEGER NOT NULL DEFAULT 0,"
  ["user_id"]=>
  string(27) "INTEGER NOT NULL DEFAULT 1,"
  ["ident"]=>
  string(33) "VARCHAR(200) NOT NULL DEFAULT '',"
  ["logged"]=>
  string(27) "INTEGER NOT NULL DEFAULT 0,"
  ["idle"]=>
  string(27) "INTEGER NOT NULL DEFAULT 0,"
  ["csrf_token"]=>
  string(32) "VARCHAR(40) NOT NULL DEFAULT '',"
  ["prev_url"]=>
  string(13) "VARCHAR(255),"
  ["last_post"]=>
  string(8) "INTEGER,"
  ["last_search"]=>
  string(43) "INTEGER, errors INTEGER NOT NULL DEFAULT 0,"
}


Warning: SQLite3::query(): Unable to prepare statement: 1, duplicate column name: errors in /var/www/???/users/blackland/www/aforum/include/dblayer/sqlite3.php on line 100

I have installed a copy of my forum on a test site, so that I do not disturb the living site. I was also able to install there phplite admin, in case I could mend the data base and put it back afterwards on the original hosting. But If I can in theory manage the data base now, I do not know what to do with it.

Go to forum: PunBB 1.4 bug reports

5 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Thanks for the direct link, I am not comfortable with the new Github.

It looks that the error is still about Create new table (line 556 of sqlite3.php)

Error when cliking on install button :


Le serveur BDD a répondu: duplicate column name: errors (Errno: 1).

Impossible d'exécuter la requête : CREATE TABLE dbtonline ( errors INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 1, ident VARCHAR(200) NOT NULL DEFAULT '', logged INTEGER NOT NULL DEFAULT 0, idle INTEGER NOT NULL DEFAULT 0, csrf_token VARCHAR(40) NOT NULL DEFAULT '', prev_url VARCHAR(255), last_post INTEGER, last_search INTEGER, errors INTEGER NOT NULL DEFAULT 0, UNIQUE (user_id,ident) );

Une erreur est apparue à la ligne 556 dans le fichier /var/www/legtux.org/users/revest/www/include/dblayer/sqlite3.php

Query at bottom of extension page :


del

Go to forum: PunBB 1.4 bug reports

6 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Thanks for helping.
With the sqlite3.php version that I found at Github, as you advised, here is the full error message when I try to install PanAntispam (the error is about Create new table):

Désolé ! La page ne peut être chargée.

Cette erreur peut être temporaire. Actualisez la page. Si le problème persiste, essayez à nouveau dans 5-10 minutes.

Le serveur BDD a répondu: duplicate column name: errors (Errno: 1).

Impossible d'exécuter la requête : CREATE TABLE dbtonline ( errors INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 1, ident VARCHAR(200) NOT NULL DEFAULT '', logged INTEGER NOT NULL DEFAULT 0, idle INTEGER NOT NULL DEFAULT 0, csrf_token VARCHAR(40) NOT NULL DEFAULT '', prev_url VARCHAR(255), last_post INTEGER, last_search INTEGER, errors INTEGER NOT NULL DEFAULT 0, UNIQUE (user_id,ident) );

Une erreur est apparue à la ligne 423 dans le fichier /var/www/legtux.org/users/revest/www/include/dblayer/sqlite3.php

Before I clicked on the install link, here is the query that was displayed :

delete

Sorry, I had never done this and do not know what to do with it.

Go to forum: PunBB 1.4 bug reports

7 Reply by Katryne

(4 replies, posted in Discussions)

Thanks for the tip Visman. Pity for sqlite.

Go to forum: Discussions

8 Reply by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Thanks for answer and links.
My punbb data base (sqlite3) seems to have some problems. I will try to reinstall everything.

Edit : my line 552 in sqlite3.php is :

        // Create new table
        $this->query($new_table) or error(__FILE__, __LINE__);

From what I understand, some extensions cannot be installed  because new table cannot be created : this table already exists.

Go to forum: PunBB 1.4 bug reports

9 Reply by Katryne

(4 replies, posted in Discussions)

Hello ! I cannot install this Pun_Approval extension since it does not comply with my 1.4.4 version of PunBB.  What can I do, please ?

Go to forum: Discussions

10 Topic by Katryne

(13 replies, posted in PunBB 1.4 bug reports)

Hello !
I am trying to fight robot registrations.
I cannot install any anti-spam extension (Fancy stop spam 1.3.52.2, Pan antispam 0.3.4, Pan Moderator 0.6.4) : I get error on line 552 of include/dblayer/sqlite3.php.
My PunBB is 1.4.4 and uses sqlite3. Php version is 7.3 and cannot be modified.

What can I do, please ?

If I try to reinstall a brand new forum, how can I recover the old messages ?  I do not know how to save and restore a sqlite3 data base. I have never done this.

Note that I was not able to login here with my old credentials for MaraKat and I had to register anew. So I am not new to this forum, since Katryne = Marakat..

Go to forum: PunBB 1.4 bug reports