Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error executing query. Mysqli #466

Closed
Szirenke opened this issue Feb 28, 2024 · 4 comments
Closed

Error executing query. Mysqli #466

Szirenke opened this issue Feb 28, 2024 · 4 comments

Comments

@Szirenke
Copy link

Szirenke commented Feb 28, 2024

Dear All,

I am trying to configure the database for web calendar (v1.9.12) and I run into the error of "Error executing query." I am using an almalinux 9 box with php 8.3.3 and I already uncommented the extension=mysqli line in the php.ini file. It says it can connect but somehow it cannot execute the mysql script. Is there something I forgot? mysql is running I can run mysql from the terminal and everything is stored in /var/lib. What is the trick here? Setting the mode to dev Gives this error:

"Table 'xycalendar.webcal_config' doesn't exist." How does one create this?

I am also wondering which file path is it asked for when I switch to SQlite3 database. I create the database and give the file path tot he database but it says it cannot connect. Which file path is it?

Thanks!

@Szirenke
Copy link
Author

Szirenke commented Mar 2, 2024

Hi,

I now tried with web calendar 1.9.10 and I am also following the actions in phpmyadmin. web calendar installation populates the database as it should but then it wants to update which probably fails and does not allow to go to next page. It seems that the database is correctly created since it can be checked in phpmyadmin. What does it want to update the database to (it has just been created why to update)?

@Szirenke
Copy link
Author

Szirenke commented Mar 2, 2024

Hi,

I am now back to version v1.9.12 of webcalendar and after I get this error:

Error executing query.

No database selected

This error also stays when I create the tables in the mysql database in phpmyadmin. No matter what I do I cannot proceed from this step. Any suggestions?

@s22-tech
Copy link

The fix can be found in this issue:

#471

@Szirenke
Copy link
Author

Szirenke commented May 2, 2024

Many thanks for this! It works now!

@Szirenke Szirenke closed this as completed Sep 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants