search

craigk5n / webcalendar

WebCalendar is a PHP application used to maintain a calendar for a single user or an intranet group of users. It can also be configured as an event calendar.
http://www.k5n.us/webcalendar.php
GNU General Public License v2.0
153 stars 75 forks source link

Error executing query. Mysqli #466

Closed Szirenke closed 1 month ago

Szirenke commented 7 months ago

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 commented 7 months ago

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 commented 7 months ago

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 commented 5 months ago

The fix can be found in this issue:

https://github.com/craigk5n/webcalendar/issues/471

Szirenke commented 5 months ago

Many thanks for this! It works now!