Joomla Templates Club 406,261 posts

[ak1design Friend ak1designJoin date: February 2008Posts: 58Downloads:0Uploads:8 Thanks: 15]

#129577

Hi,

I could not install the ja_teline_ii_quickstart_v1.3_1.5.3 but it giving me this message
” The MySQL Database name Must start with a letter, and be followed by only letters, numbers or underscore” and this is mine: web53-mzinet i have contacted my web hosting provider and they advise me to contact my template provider.

is there any help.
the normal joomla install 1.5 smoothly but not with ja_teline_ii_quickstart_v1.3_1.5.3

many thanks

---

Attachments:

1. 

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253094

<em>@ak1design 58481 wrote:</em><blockquote>Hi,

I could not install the ja_teline_ii_quickstart_v1.3_1.5.3 but it giving me this message
” The MySQL Database name Must start with a letter, and be followed by only letters, numbers or underscore” and this is mine: web53-mzinet i have contacted my web hosting provider and they advise me to contact my template provider.
</blockquote>

Hi ak1design,

Do you happen to be in a shared server hosting service?

What is the site username that you used when you registered?

If you are, then the usual full name of a MySQL database would be like this:

siteusername_dbname

where

siteusername => is the master username associated with your domain. In some webhosting services, the length is sometimes limited to 8 or so letters and numbers.

and

dbname => is the specific name of one of your databases (and you might have a few)

Very critical => No hyphen or underscore nor any other symbols in either the siteusername or dbname.

but note the underscore that separates the siteusername and the dbname so that the actual full MySQL database name is:

siteusername_dbname

as the name implies, shared servers customers also share the same database server. In some hosting services, the latter database server (shared with other customers) is separate from the server that contains your actual website that is also (shared with other customers).

If you consider the above protocol, in a shared database server your siteusername is the only that distinguishes your own databases from other databases owned by others in the same shared database server.

So, let us take your example:

web53-mzinet

Case 1 violation:

whether the above name is either a siteusername or a dbname, you violate the rule not to have any hyphen (-) in either siteusername or a dbname.

I hope the above is clear.

Case 2 violation:

If the siteusername is web53 and the dbname is mzinet then you still violate the full database nomenclature because you used a hyphen (-) not an underscore (_)

for case 2, it should be web53_mzinet not web53-mzinet assuming web53 and mzinet are the siteusername and the dbname , respectively.

Case 3 violation:

If web53-mzinet is just the dbusername (the second part of the full database name), even if you correct it by removing the hyphen, i.e., web53mzinet, may still be in violation and not acceptable by the shared database server, if your hosting company has a policy to limit the dbname.

Important Note:
Note that the aforementioned is not observed in dedicated server, because more than likely it is also your database server that you must own exclusively — otherwise, you are being taken advantaged of by your hosting service.

I hope all the above are clear.

<em>@ak1design 58481 wrote:</em><blockquote>
is there any help.
the normal joomla install 1.5 smoothly but not with ja_teline_ii_quickstart_v1.3_1.5.3

many thanks</blockquote>

I find this statement confusing. Are you stating that you did not run into a problem while installing a normal joomla install 1.5 with its own database (possibiy setup like above) and you encountered the problem only as you stated above with ja_teline_ii_quickstart_v1.3_1.5.3????

If this is the case, everything I stated above is negated.

What was the full database name that you used for your normal joomla install 1.5???

As to ja_teline_ii_quickstart_v1.3_1.5.3 installation, a majority of the problems and questions posted here seem to be related to ja_teline_ii_quickstart_v1.3_1.5.3. I did not encounter any problem, but a number of people did.

My own bias is that if you are not as yet experienced, it is better to start with the QuickStart kit for Joomla 1.0x plus JA Teline II

http://www.joomlart.com/forums/downloads.php?do=file&id=493
File Name: JA Teline II v1.2 for Joomla! 1.0.x (7.68 MB) Download
Author: JoomlArt (Uploaded by kashxo)
Date Added: 05-07-2008
Downloads: 2020
Grade: A+

JA Teline II v1.2 for Joomla 1.0.x.zip => unzip => JA Teline II v1a 1.0.x-1 Folder => three folders inside => go to QuickStart folder => unpack => ja_teline_ii_1.0kstart_v1.2 => upload the whole ja_teline_ii_1.0kstart_v1.2 only folder via FTP

Cornelio

If indeed you are in a shared server, and it was technical service who told you to come here, then the hosting service that you are on now has a very bad technical support, or do not really care about you as a customer. You should start packing your site and look for another hosting service.

Database nomenclature should be the least of the problems that you will encounter running a website, if technical support there was not able to identify your error, more than likely you will have greater problems with them when more critical incompatibilities or problems occur.

[Menalto Friend MenaltoJoin date: May 2007Posts: 4736Downloads:0Uploads:43 Thanks: 2 Thanked: 531 times in 361 posts]

#253096

This was also an error in 1.52 version of joomla wich they fixed in 1.5.3-

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253102

<em>@Menalto 58492 wrote:</em><blockquote>This was also an error in 1.52 version of joomla wich they fixed in 1.5.3-</blockquote>

What do you mean, Menalto? Please clarify.

Cornelio

[ak1design Friend ak1designJoin date: February 2008Posts: 58Downloads:0Uploads:8 Thanks: 15]

#253107

thank a lot for your reply,

my hosting provider provides a joomla 1.5. 3 automatic install in my cpanel. for my dbase the word “web53-” is automaticaly added to the name i choose like this mzinet so it will be: web53-mzinet and as i mentiones if I use a normal install it works perfectly but i have to do myself every thing which is a nightmare.

I realy dont want to go back to joomla 1.0x but if it is the only solution i will sad:((

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253132

<em>@ak1design 58507 wrote:</em><blockquote>thank a lot for your reply,

my hosting provider provides a joomla 1.5. 3 automatic install in my cpanel. for my dbase the word “web53-” is automaticaly added to the name i choose like this mzinet so it will be: web53-mzinet and as i mentiones if I use a normal install it works perfectly but i have to do myself every thing which is a nightmare.

I realy dont want to go back to joomla 1.0x but if it is the only solution i will sad:((</blockquote>

Hi ak1design,

Based from your clarification, as I explained in detail above, your error is very simple. It should be written as:

web53_mzinet

Note that for the full database name, you should use an underscore, not a hyphen between the siteusername and the dbname

Try writing it as suggested above, and let us know what happens. If it does not work, then the problem might be what Menalto alluded to.

No, you really do not have to go back to Joomla 1.0x. Just make sure to read what problems, errors, or issues already posted here by those using Joomla 1.5x, so that you do not commit the same mistakes.

When you stated automatic install of Joomla 1.5.3, is this just for the Joomla itself, or is it also for Joomla1.5.3-JA Teline II QuickStart kit? If they allow automatic installation of the QuickStart Kit, that might help, and a little bit easier.

Cornelio

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253142

Hi ak1design,

I looked at the figure you provided. It seems you made a similar error in the entry you made in the User Name also.

If it gives you the error again, try for the entry in the username:

web53_mzinet

Use an underscore not hyphen, also.

I noticed that your full Database Name and your User Name are the same. This is not a good idea. It is better to avoid confusion to have a Database Name and your User Name because it is possible to have more than one user of the database.

You may do as wish of course, so just take this as an observation

Cornelio

[ak1design Friend ak1designJoin date: February 2008Posts: 58Downloads:0Uploads:8 Thanks: 15]

#253276

Hi, Thanks all,

for the web53_mzinet I can’t change it to underscore as it is automalicaly generated by the MuSQL so if i create a new names like “mysite” it will be automaticaly created as “web53-mysite”
for the username and database name yes they are the same as my hosting provider says they should be the same.

I tried with the underscore ” web53_mzinet” but it give me this message:
Unable to connect to the database:Could not connect to MySQL

my hosting provider provide the standard joomla installated not the quickstart. as when i install the standard it works perfectly, but again i have to spend a lot of time installing the rest of the other com_’s and Plug ins
:confused:

[Menalto Friend MenaltoJoin date: May 2007Posts: 4736Downloads:0Uploads:43 Thanks: 2 Thanked: 531 times in 361 posts]

#253282

which host do you use?

[ak1design Friend ak1designJoin date: February 2008Posts: 58Downloads:0Uploads:8 Thanks: 15]

#253288

http://www.heartinternet.co.uk i got a reseller account on linux

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253289

<em>@ak1design 58707 wrote:</em><blockquote>Hi, Thanks all,

for the web53_mzinet I can’t change it to underscore as it is automalicaly generated by the MuSQL so if i create a new names like “mysite” it will be automaticaly created as “web53-mysite”
for the username and database name yes they are the same as my hosting provider says they should be the same.

I tried with the underscore ” web53_mzinet” but it give me this message:
Unable to connect to the database:Could not connect to MySQL

my hosting provider provide the standard joomla installated not the quickstart. as when i install the standard it works perfectly, but again i have to spend a lot of time installing the rest of the other com_’s and Plug ins
:confused:</blockquote>

Hi ak1design,

Based from your report, this is clearly an issue that must be resolved by the technical support of your webhosting service. It is obvious that the full name

web53-mzinet

caused the error you stated in your original post.

” The MySQL Database name Must start with a letter, and be followed by only letters, numbers or underscore”

The fact that the above uses a hyphen, if the violation, and caused the error in the above full name.

And yet, when the standard convention, that I know is used by many shared server hosting (and as pointed out by the error to be the correct format):

web53_mzinet

is not accepted. This contradicts the advice indicated in the error message.

You must discuss this issue with your hosting service because the database nomenclature has nothing to do with Joomla or the Joomlart template.

All programs that require a database will have the same database nomenclature.

If they cannot resolve this with you, they are not offering you a good service if they are passing it to Joomla or the template creator to solve this issue.

If they refuse to resolve this, consider moving to a better hosting service with a good technical support. That was one of the main criteria when I moved my site. I also make sure that the hosting service provider I chose a Forum for the customers because more than likely they would experience the same issues that you experience.

I understand your situation and it is very difficult to find a good webhosting provider. How big is your site right now?

I see nothing wrong with your QuickStart installation, based from the figure you provided. If you read the procedure carefully, and read the solved issues here already, there should be no problem with your installation — even with the more difficult Joomla 1.5.3 — JA Teline II QuickStart Kit.

It may boost your confidence if you can prove that you can install the QuickStart Kit easily.

If you want, I have several multisite accounts with my hosting, where each domain has their own separate Control Panel.

I can set up one for you temporarily (and for free) so that you can try installing a Joomla 1.5.3 — JA Teline II QuickStart Kit.

Cornelio

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253319

Hi ak1design,

I just sent you a private message. Let me know if I missed anything.

Good luck

Cornelio

[cgc0202 Friend cgc0202Join date: August 2007Posts: 2244Downloads:0Uploads:3 Thanks: 206 Thanked: 262 times in 1 posts]

#253337

<em>@ak1design 58721 wrote:</em><blockquote>http://www.heartinternet.co.uk i got a reseller account on linux</blockquote>

Hi ak1design,

I looked briefly at the hosting service —

http://www.heartinternet.co.uk

their terms are too good to be true. If they do not have any Forum, it is suspect how satisfied their customers are.

My current hosting service has a very low diskspace allocation for resellers:

feature info Disk Space Pool 12 GB
feature info Bandwidth Pool 1 TB
feature info IP Addresses Included 3
Monthly Price (full pricing below) $14.95/month

“unlimited database, sites, email, FTP, etc. provided the disk space usage does not exceed limit above”

There are two other plans for $20 & $50/m

The above seems stingy, but they are along the lines of what you expect if the number of accounts are limited per server.

Cornelio

[Author]

Posts