#207 invitations_uploads/options error creating database

[frederic]

Hello and thank you very much for your work openup is more than ever so beautiful you make a very good job whith .css it's stylish (i'm swiss-french excuse my poor english )
But i have a bug i think beaucause 2 "lignes" in the database are not created invitations_uploads and invitations_upload_options i'm running php 7.0.30 mariadb 5.5.59 all the others tables are ok
https://imgur.com/VIfx4dD
https://imgur.com/7xcYwmU

https://imgur.com/Mt5awQP

thank you for your help

[frederic]

It's ok i have create the databases whith the file structure.sql whith sql request
CREATE TABLE IF NOT EXISTS invitation_options (
invitation_id varchar(100) NOT NULL,
seq int(11) NOT NULL,
module varchar(50) NOT NULL,
name varchar(50) NOT NULL,
value varchar(200) DEFAULT NULL,
PRIMARY KEY (invitation_id,seq)
) ;

CREATE TABLE IF NOT EXISTS invitation_upload_options (
invitation_id varchar(100) NOT NULL,
seq int(11) NOT NULL,
module varchar(50) NOT NULL,
name varchar(50) NOT NULL,
value varchar(200) DEFAULT NULL,
PRIMARY KEY (invitation_id,seq)
) ;
It work's but i have some error whith

Integrity constraint violation: 1048 Column 'expire_date' cannot be null' in /volume1/web/open/lib/modules/db/pdo_mysql.inc.php

https://imgur.com/KXI4xfe

I don't now how to solve it !
Maybe if email work it will be more easy to understand what's happen but they don't be sent(i have port 25 open in routeur my SMF'email forum work but none for openup i don't know why

thanks for your help
best regards

[frederic]

And for registration i Have an error to
https://imgur.com/DRDos74 this line is probleme how to wright that correctly
$vlist .= '\''.mysqli_real_escape_string($this->db,$values[$f]).'\'';
because the name wasn't register in base
https://imgur.com/oolENav

i try and try but i don't know php
if i put
$vlist .= '\''.mysqli_real_escape_string($this->db,$f).'\'';
i have
https://imgur.com/i5ClppU

I really need help thank you

[frederic]

I changed the line in /lib/modules/defaut/auth.inc.php

if (ereg_replace('[a-zA-Z0-9_]*','',$_POST['registerlogin'])!='') {
per

if (preg_match('[a-zA-Z0-9]*','',$_POST['registerlogin'])!='') {

this time the user is put in database
https://imgur.com/j1ET8cE
But when this user wants to log in
A big error message that this
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_login' cannot be null' in /volume1/web/open/lib/modules/db/pdo_mysql.inc.php:182 Stack trace: #0 /volume1/web/open/lib/modules/db/pdo_mysql.inc.php(182): PDOStatement->execute() #1 /volume1/web/open/lib/main.inc.php(91): pdo_mysqlDB->insert('activitylog', Array) #2 /volume1/web/open/lib/user.inc.php(96): Application->log('security', 'authenticate', '', 'DENY', 'Login failed: f...') #3 /volume1/web/open/lib/modules/default/auth.inc.php(63): OpenUploadUser->authenticate() #4 /volume1/web/open/lib/main.inc.php(250): AuthModule->authenticate() #5 /volume1/web/open/www/index.php(72): Application->run('login', '2') #6 {main} thrown in /volume1/web/open/lib/modules/db/pdo_mysql.inc.php on line 182

I use the openupload-openupload-code-d1c5fc0eaa8d9b5bc514b6f20cc92139e0f9ba76
and openupload-openupload-code-c80a022b384dcb957505a31e65b69062168062d5

I'm not familiar whith the repository is some files more fresh/new files i can use ???

Now I can't go any further with my knowledge.

Thank you

[Anonymous]

Is there only one here ???

[frederic]

Up
thanks

[Alessandro Briosi]

Sorry for the late reply. I have been working on OpenUpload to update it for php7 compatibility, though haven't had the time to test it completely yet.
The setup script in GIT was updated and should work with mysqli and pdo_mysql, dunno why it didin't create the invitations.

[Alessandro Briosi]

BTW, are you using mysqli or pdo_mysql?

[frederic]

Ok I start from the beginning with, openupload-openupload-code c80a022b384dcb957505a31e65b69062168062d5
and i use PDO_MYSQL and
https://imgur.com/VIfx4dD

1st problem when creating the database: invitations_options and invitations_uploads_options databases are not created
https://imgur.com/LrfwDIK

So I create them myself

Then there's a folder problem that doesn't create either, the data folder containing template_c and tmp

that it doesn't matter I create them too
https://imgur.com/7XONgkz
https://imgur.com/vgqMiSO

Then there's a third problem
when registering a testuser user
there's this error message
https://imgur.com/xJ6KveG
I would point out that I left the
if (ereg_replace('[a-zA-Z0-9_]*','',$_POST['registerlogin'])!='') {
as it was at the beginning, I didn't touch any lines of code

the registration is indeed done in the database
https://imgur.com/yfoxWXo
https://imgur.com/VMbbujX

but during login there is this error message
https://imgur.com/MpbbP2U

The emails aren't sent but I think that's a problem on my side.
and doesn't impact the login because yesterday when I got the one and only email it was the same message I think because I didn't think to make a screenshot
(I'll try this afternoon and send you the screenshot)

It's very hard to explain all this I hope I've been clear enough if you need more information do not hesitate
to ask me for them or some other installation with other files or whatever.

Thanks for your help. It was really nice of you to answer me with all that work.
Have a nice day

Translated with www.DeepL.com/Translator

[frederic]

The invitations as well as the uploads work and even the mails are sent, on the other hand the mail of the invitation is badly formed I put the mail text in attachment to you

https://imgur.com/N6IWh7b
https://imgur.com/2iSynS3
https://imgur.com/UlNkCza
https://imgur.com/k2ZdG8i
https://imgur.com/9nsfx5b

A+

[frederic]

there is still a problem with upload invitations when I put the file browse> upload
https://imgur.com/KXhuz5H

I get this mistake
https://imgur.com/WiINc1U