Counter - sql querry ?

that's weird, amybe something for your host to figure out?

I figured out why I have so many problems, the installation of phpadmin on the one.com server is false.

If I click the "pen" icon in the settings table, nothing happens. Cause the hyperling is "tbl_row_delete.php"

In all the other tables ex. user table, if I click the pen icon is more like "http://phpmyadmin.snowatom.com/tbl_change.php?lang=da-iso-8859-1&server=1&db=snowatom_dk&table=fusion_users&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60user_id%60+%3D+%271%27&sql_query=SELECT++%2A+%0AFROM++%60fusion_users%60+&goto=sql.php"

So something must be wrong since the edit butten for the settings table, only have such a bad hyperlink.

snowatom

hehe, we all do those small mistakes from time to time :D

Here's where the "pen" icon comes in! lol.

Click it, the one to the left of the layout. Now you get a new page with editable stuff! Save with the run/save or whatever it says in the bottom of the page :)

DAMN STUPID ME :D

Well, thanks now i can see the actual number of the counter, strange I can't edit it in the database in phpmyadmin though.

you have to scroll like a mile to the right!

If i click that icon, I can't find any info on the counter.

I get the welcome messege info, that I use in the fusion site

snowatom

haha, wait it's not a pen, i remembered wrong!

look at this one. Click the paper i circled!

Heres the funny part, this is the image I get when clicking the pen icon.

snowatom

yes, click the "pen"-looking image on the left side table and you'll get to where you want to be :D

No. You look at the Database Table in Structure Mode. This Shows the Default Value which is 0. You need to click the View tab on top to get to the actual Values stored in the DB

You know, I think that the database you are browsing in phpmyadmin is for a different website to the website you are using. Hence the different values for Counter, Version and locale.

Well, that works ok. BUT why is the counter as written above not the same in the database as in the site.

The attached picture shows the database of my fusion, the counter is now aprox 103 - why can't I see that in the phpmyadmin database ?

It seems to show 0 in the database shown in PHPmyadmin.

snowatom

Put the following code into a new custom page and PREVIEW ONLY - dont save (change 999 to the number you want)

i just tryed to change the counter number like you said, to 200 just to test it.. nothing happend.. i still says 5, like before

okay.. thx :)
if i change it to a nother number myself, will the counter function still work?
my counter state says 4 right now when i visit my site. But in phpmyadmin under settings - counter - it says 0. will it not wreck the counter if i change the 0 til another number?

And i just noticed that under settings - version - it says : 6.00.400
and in Locale it says English

why? im running v.6.01.6 in Danish Locale.

sorry for asking so much.. i just want to be safe

You can find the Unique Visits count in your database. It is in the "settings" table, under the "counter" field. Simply edit it to what you were at before.