Easy PHP Calendar - We really take care of your dates!


Go Back   Easy PHP Calendar > General Discussion > General Support

General Support Questions about using the Easy PHP Calendar. (Not installation or customizations)

Closed Thread
 
Thread Tools Search this Thread Display Modes

mySQL Database Error
Old 03-02-2006, 12:04 AM   #1
pr0grammerMX
Calendar User
 
pr0grammerMX is offline
Join Date: Feb 2006
Posts: 14
Default mySQL Database Error

I have set up the mySQL database with my web hosting provider, but I receive the following message when I try to enter or exit the Add Event setup:

> The connection to the mySQL database was successful!

> There was an error creating the mySQL database table.

The error was reported as:
CREATE command denied to user: '******_*****@xxx.xxx.xx.xxx' for table 'epc_calendar'

This is one of the first messages I receive as well:

"Please click to run the installation script, setupSQL.php to set up the database.

The error was reported as:

Table '******_calendar.epc_calendar' doesn't exist


No events will be saved until this issue is resolved."

I have gone to the setupSQL.php link and have created it, but then I receive that first message above.

Any help would be great!
 

Old 03-02-2006, 06:46 AM   #2
ve9gra
Support Team
 
ve9gra's Avatar
 
ve9gra is offline
Join Date: Jun 2003
Location: New Brunswick, Canada
Posts: 4,965
Default

You need to make sure that the user you've entered in the database section actually has rights to create a database. Quite often, you have to create the database first using whatever process your host has in place. Once that's done, it usually creates a user to go along with that database. If you already have a database created that you use for other installations, I suggest that you use that database along with the user that was assigned to that DB.

When you'll have the right user and right database entered in the settings, it should come up again with the setupSQL.php link. Clicking it will create the table in the DB you've specified. After that, you'll be able to enter and save events using the Events Manager.

PS: The reason why you want to use the same database is that if you are using the calendar inside of a content management system (Nuke, Joomla, phpWS, etc...) anything that is supposed to appear after the calendar won't show up. The reason is because the CMS establishes its connection to the database at the begining of the script and assumes the connection will stay active until the whole page is loaded. So if you display the calendar midway, using a different DB, the CMS will try to find the info it's looking for in the calendar DB, which will fail.
__________________
-- Gervais
EPC Tutorials... We're here to help!
Offering custom integration services. Contact me here.
* Not affiliated with EasyPHPCalendar or NashTech Inc.
 
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
There was an error connecting to the mySQL database. emrfixit Installation / Upgrade Questions 7 12-03-2005 08:25 AM
Database key mismatch error. Meadowlark General Support 14 01-13-2005 04:16 PM
Database key mismatch error slyeli General Support 1 09-24-2004 08:47 AM
an error writing to the flat-file database 'esdates.txt' Squirrel General Support 12 07-28-2004 12:02 AM
error connecting to the mySQL datab, please help kaotik General Support 10 03-03-2004 12:55 AM



All times are GMT -4. The time now is 05:38 AM.


vBulletin skins developed by: eXtremepixels
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright 2009 NashTech, Inc.

| Home | Register | Today's Posts | Search | New Posts |