Admin

Locked

Started by cheryl_mccain on 30 Sep 2006, 11:43 AM · Views: 2,789

Results 1 to 19 of 19
This thread is locked. New replies are disabled.
30 Sep 2006, 11:43 AM
#1
cheryl_mccain avatar

cheryl_mccain

New Zenner

Join Date:
May 2006
Posts:
13
Plugin Contributions:
0

Admin

I have upgraded Zen, the store is showing but when I try to go to Admin, here's what I'm getting. I have no clue what this means. Can someone help?

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks!

30 Sep 2006, 11:54 AM
#2
pixxi avatar

pixxi

Totally Zenned

Join Date:
Jan 2004
Location:
UK
Posts:
1,065
Plugin Contributions:
1

Re: Admin

0 DB_ERROR_NOT_CONNECTED

It means you haven't supplied the correct user name/password/database name for your database, and as a result the shop can't connect to the database.

You can edit the settings in your shop/includes/configure.php and in your shop/admin/includes/configure.php.

If your shop is showing products and working Ok. then it will probably be your admin/includes/configure.php file that needs editing.

If you do a search on '0 DB_ERROR_NOT_CONNECTED' on the forum you'll find lots of posts.

30 Sep 2006, 7:32 PM
#3
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: Admin

Just have a look at includes/configure.php and admin/includes/configure.php to see if you have the right values for the database username and password
San

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

1 Oct 2006, 12:10 PM
#4
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

please guide me, how cn i setup the local time of my zone /at the top of admin/
Sun, 01 Oct 2006 12:02:48 +0000GMT [127.0.0.1 ]
tnx

save nature = save water

1 Oct 2006, 12:44 PM
#5
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: Admin

LostSheep:

please guide me, how can i setup the local time of my zone /at the top of admin/
Sun, 01 Oct 2006 12:02:48 +0000GMT [127.0.0.1 ]
tnx

Hi
LostSheep
That time is set in \admin\includes\header.php

<td class="headerBarContent" align="center"><b><?php echo date("r", time()) . 'GMT' . ' [' . $_SERVER['REMOTE_ADDR'] . ' ] '; ?></b></td>

As you see by default it is GMT timezone
Which timezone are you in?
Depending on that you would have to use the setlocale
http://us2.php.net/manual/en/function.setlocale.php

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

1 Oct 2006, 1:47 PM
#6
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

thank u superprg boy
yr reply is so rapid and i appreciate it much

save nature = save water

1 Oct 2006, 1:54 PM
#7
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: Admin

LostSheep:

thank u superprg boy
yr reply is so rapid and i appreciate it much
Thanks, but did that solve the problem?
Do let us know how you do it and if you face any problems etc
San

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

5 Oct 2006, 4:58 PM
#8
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

i messed up with the time zone so i refreshed old and let it untouched for a while
i'll be back to it
thank u anyway for your advice

save nature = save water

6 Oct 2006, 4:45 AM
#9
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Admin

Create a file time_offset.php which contain a TZ variable for the time zone where you are, put it in...

admin/includes/extra_configures/time_offset.php

For example mine contains..

<?php  
//You can modify the TZ (Time Zone) by using one of the following offsets 
//TZ=America/Los_Angeles 
//TZ=America/Denver 
//TZ=America/Chicago 
//TZ=America/New_York 

putenv ('TZ=Australia/Melbourne');  
?> 

you need to change

putenv ('TZ=Australia/Melbourne');

to what ever your time zone is, you may have to google to find the valid text for your time zone


7 Oct 2006, 1:05 PM
#10
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

thank you glby for your reply. it doesnt work in my case. i googled there about my zone and didnt find a thing about time zone offset. so would you please guide me through this procedure. my location is in ulaanbaatar mongolia.

save nature = save water

7 Oct 2006, 1:43 PM
#11
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

is it here in attributes_price_factor_onetime_offset. if so how it could be done. my zone is gmt+08:00.

save nature = save water

7 Oct 2006, 2:04 PM
#12
pixxi avatar

pixxi

Totally Zenned

Join Date:
Jan 2004
Location:
UK
Posts:
1,065
Plugin Contributions:
1

Re: Admin

IIRC, putenv/set locale will correct your display time in admin, but it won't affect the date/time entered into the database for orders or order confirmation/update emails - that will still be based on server time since the code uses the MySQL 'now()' function.

You might take a look at the Time Zone Offset mod for a better solution:

https://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=145

[Edited: the 'add URL' button doesn't seem to be working on replies to posts today :-) ]

7 Oct 2006, 5:05 PM
#13
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

thank u pixxi for quick reply. i setup the zone as yr guidance. anyway is it possible to change/add the admin time in admin/includes/header.php line 218, for example, time(+0800) or whatever?

save nature = save water

7 Oct 2006, 5:10 PM
#14
pixxi avatar

pixxi

Totally Zenned

Join Date:
Jan 2004
Location:
UK
Posts:
1,065
Plugin Contributions:
1

Re: Admin

If you've installed the Time Zone Offset mod, then you can set the time offset for your country compared to server time (GMT+8) in the shop admin:

admin->configuration->My Store->Time Zone Offset

7 Oct 2006, 5:21 PM
#15
seethrou avatar

seethrou

Totally Zenned

Join Date:
May 2004
Location:
Hong Kong
Posts:
1,156
Plugin Contributions:
0

Re: Admin

@ LostSheep

From you post

LostSheep:

please guide me, how cn i setup the local time of my zone /at the top of admin/
Sun, 01 Oct 2006 12:02:48 +0000GMT [127.0.0.1 ]
tnx
And from your signature
zc1.3.5; localhost; windows xp; apache; mysql5.0.24a; php5.1.6
Are you also want to change the time of your local server in your windows xp?
If it is the case, find or add the following section in you php.ini (only valid for PHP > v5.1) and add the support for your timezone.

[Date]
; Defines the default timezone used by the date functions
date.timezone = Etc/GMT+8

Note: in the above
Etc/GMT+8
is only suggestion and you may find a better one for your timezone.

Reference:
XXII. Date and Time Functions
Appendix H. List of Supported Timezones
List of timezones in the group Others

.

A New Starter again

7 Oct 2006, 5:58 PM
#16
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

thank u buddys. it seems ive done it.

save nature = save water

7 Oct 2006, 6:12 PM
#17
seethrou avatar

seethrou

Totally Zenned

Join Date:
May 2004
Location:
Hong Kong
Posts:
1,156
Plugin Contributions:
0

Re: Admin

Glad to hear that. :smile:

.

A New Starter again

8 Oct 2006, 1:26 AM
#18
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Admin

LostSheep:

thank you glby for your reply. it doesnt work in my case. i googled there about my zone and didnt find a thing about time zone offset. so would you please guide me through this procedure. my location is in ulaanbaatar mongolia.

Try...

putenv ('TZ=ULAT/ULAST');

reference from
http://home.tiscali.nl/~t876506/TZworld.html

PS: TZ doesn't work on all servers apparantly.

8 Oct 2006, 4:29 AM
#19
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: Admin

thank u gilby, thats it. i found my answer in reference u gave. tnx

save nature = save water