You are not logged in. Please login or register.
LuxCal Web Calendar → Problems → cannot login after new install
Pages 1
Hi Roel,
I did a new install on one of my websites.
When doing a first login, that does not work
and the sqllog file shows the following message:
mycal:ERROR Script: /linski_cal/index.php - SQL execute error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'token' in 'field list'
How can this be solved?
Thanks in advance for your reply.
BR, Piotr Linski
Hi Piotr,
To say something useful I need some more details.
Was it a new installation, or an upgrade?
Did you install the latest version (V5.2.1)? The MySQL or the SQLite version?
Was the installation itself successful?
What happens "exactly" when you try to log in? Error message? or Unknown username/password?
An other option is to send me a .sql copy of your calendar database, so that I can see what's wrong and repair it.
Roel
Hi Roel,
It is a new installation.
Latest version 5.2.1, the mysql version.
Installation itself was succesful, the calendar is shown.
When I try to login, login fails and I get the message: SQL error. See 'logs/sql.log'
Hi Piotr,
That's really strange. the column "token" is absolutely part of a newly created users table. So if the installation went fine, then the column token should be part of the table.
The token was introduced in version 5.1.0 to remedy an authentication vulnerability. Could it be that you accidentally mixed the V5.2.1 files with an older calendar version? In particular the "common/toolboxx.php file. The correct toolboxx.php file should show on line 299 ;
`token` VARCHAR(32) NOT NULL DEFAULT '',Let me know if this is the case and then we will take it from there.
Roel
Hi Piotr,
That's really strange. the column "token" is absolutely part of a newly created users table. So if the installation went fine, then the column token should be part of the table.
The token was introduced in version 5.1.0 to remedy an authentication vulnerability. Could it be that you accidentally mixed the V5.2.1 files with an older calendar version? In particular the "common/toolboxx.php file. The correct toolboxx.php file should show on line 299 ;`token` VARCHAR(32) NOT NULL DEFAULT '',Let me know if this is the case and then we will take it from there.
Roel
Hi Roel,
I have checked, and I am 100% sure that I did not mix-up.
And line 299 shows exactly what you wrote above.
BR, Piotr
Hi Piotr,
There are a couple of things you could do:
• Via your browser you can run the script upgrade521.php (in the calendar root folder). This will re-generate your database without loss of data.
• Via your browser you can run the script install521.php (in the calendar root folder) and create an additional calendar. If this new calendar works you can delete the original calendar from the database.
• You can send me a .sql copy of your calendar database and I will repair it. (my preference, because I'm curious to see what is wrong).
Roel
Hi Roel,
Have also a bug in update from 5.1.0M to 5.2.1M
Token etc error, mycal_ users had no token field, I added it manually.
Now, the error in the log is "Query string: INSERT INTO `mycal_stylesX` SELECT DISTINCT * FROM `mycal_styles` WHERE `name` != 'THEME'"
If the update521.php is deleted, error ... file missing
If not deleted, the error in the log as shown before.
I have zero possibility to go to the calendar directly (../calendar521)
I want to keep my data, tried an upgrade, a new install and import the calendar, nothing works.
I'm quite upset and I have another calendar to migrate which is in v 4.7.8, I 'm really anxious about it ...
Any key ?
News,
I don't know how .. calendar is now operative after having done and delete 3 or 4 times new installs ..
Operative but ...
I have an issue with users.
I can log as ans admin but others users have an empty token field so that they're not able to log and they create an SQL issue.
Tried to use the upgrade521.php, makes an error and does not seem to do anything
mycal_users and _usersX both contain token value for me but different values.
I don't know what this field is suposed to be/do, and what happens if I try an random value.
Trying to read Users table cal in the app also creates a bug :
Fatal error: Uncaught TypeError: implode(): Argument #1 ($pieces) must be of type array, string given in /homepages/7/d336518503/htdocs/calendrier521/common/toolboxd.php:110 Stack trace: #0 /homepages/7/d336518503/htdocs/calendrier521/common/toolboxd.php(110): implode(',', NULL) #1 /homepages/7/d336518503/htdocs/calendrier521/pages/users.php(40): stExec(Object(PDOStatement), NULL) #2 /homepages/7/d336518503/htdocs/calendrier521/pages/users.php(227): listUsers() #3 /homepages/7/d336518503/htdocs/calendrier521/index.php(285): require('/homepages/7/d3...') #4 {main} thrown in /homepages/7/d336518503/htdocs/calendrier521/common/toolboxd.php on line 110
Any key ?
Hi Hubert,
I'm a bit confused by the explanations of your last two posts.
Could you send me an email (via the contact page) and explain to me step-by-step what you have done and what is going wrong please.
Roel
I send you an email.
Now, After xx reinstalls, it works but only with 1 user, issue and crash with users table ...
Hi all,
Issue solved, Roel had a key for it, I applied and all came back ok.
Now, my 521 calendar is fully operative and I can forget my test platform ...
Many thx Roel for quick resolution (as usual) !
Hubert
Pages 1
LuxCal Web Calendar → Problems → cannot login after new install