« previous next »
Pages: [1]

Author Topic: Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767  (Read 15717 times)

0 Members and 1 Guest are viewing this topic.

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« on: February 24, 2006, 04:04:47 PM »
hello evrybody here

i hope to get help about this problem

i tried this (ALTER TABLE `4images_categories` CHANGE `cat_hits` `cat_hits` INT( 10 ) DEFAULT '0' NOT NULL)

but the problem still and the total of images stoped (13149) and the categories also stoped (145)

how can we fix this problem

Best Regards,
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #1 on: February 24, 2006, 11:57:30 PM »
Quote from: RED_LINE on February 24, 2006, 04:04:47 PM
but the problem still and the total of images stoped (13149) and the categories also stoped (145)
Total of images? and how many images do you actualy have? I'm pretty much sure that the problem you have (if any), is not related to type of fields in the database, because total number of images is being counted by mysql itself, based on how many entries exists in the database....
With phpmyadmin you can see how many entries 4images_images table has, also, buy running this query it should show you the number of images and it should match what phpmyadmin shows:
Code: [Select]
SELECT COUNT(image_id) AS num FROM 4images_images
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline IcEcReaM

  • Hero Member
  • *****
  • Posts: 714
    • View Profile
    • My little Testboard
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #2 on: February 25, 2006, 12:46:51 AM »
Better would be
Code: [Select]
SELECT MAX(image_id) AS num FROM 4images_imagesCause your query shows only the number of images,
but beacuse of autoincrementing it would be better to know where which is at the moment the highest image id.

But i think too, that your problem isn't relating to this topic.
« Last Edit: February 25, 2006, 01:53:20 AM by IcEcReaM »
Logged
Coding is a everlasting competition between programmers who tries to write larger, better and idiot-safe programs and the universe producing larger and stupider idiots...
...so far the universe won
bump

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #3 on: February 25, 2006, 01:01:32 AM »
Quote from: IcEcReaM on February 25, 2006, 12:46:51 AM
Better would be
Code: [Select]
SELECT COUNT(image_id) AS num FROM 4images_imagesCause your query shows only the number of images,
but beacuse of autoincrementing it would be better to know where which is at the moment the highest image id.
You've lost me there...the query is identical ;)

and here is where to look in phpmyadmin:
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline IcEcReaM

  • Hero Member
  • *****
  • Posts: 714
    • View Profile
    • My little Testboard
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #4 on: February 25, 2006, 01:53:10 AM »
Sorry was my fault, cause i just copy & pasted for easier posting.

i wanted to write not count but max

I've changed my post above
Logged
Coding is a everlasting competition between programmers who tries to write larger, better and idiot-safe programs and the universe producing larger and stupider idiots...
...so far the universe won
bump

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #5 on: February 25, 2006, 02:13:32 AM »
Oh, I see what you mean...either that or it also can be looked up from phpmyadmin, on the screenshot the field "Next Autoindex".

@RED_LINE:
Please make a screenshot of your 4images_images table structure with phpmyadmin (or use export feature and select only the structure to export)
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #6 on: February 25, 2006, 03:21:56 PM »
hello V@no

i tried the command and the total images i have is 15600 in admin area and phpmyadmin ( num 15600 ) but in the main page the total images is 13149 !! also the categories in the admin area is 167 but in the main page is 145 !

Best Regards,
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #7 on: February 25, 2006, 06:00:28 PM »
on home page it shows number of categories/images which you have permission to view, and if you are logged in as admin, they should be equal to what you see in ACP.
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #8 on: February 25, 2006, 07:56:32 PM »
Quote from: V@no on February 25, 2006, 02:13:32 AM
Oh, I see what you mean...either that or it also can be looked up from phpmyadmin, on the screenshot the field "Next Autoindex".

@RED_LINE:
Please make a screenshot of your 4images_images table structure with phpmyadmin (or use export feature and select only the structure to export)

hello V@no



thank you fot help
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #9 on: February 25, 2006, 08:24:53 PM »
The question is did you check the home page being logged in as admin?
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #10 on: February 25, 2006, 09:24:52 PM »
hello

yes when i loggen in as admin i see the total of images and categories is ok

Regards,
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #11 on: February 25, 2006, 09:26:29 PM »
Quote from: V@no on February 25, 2006, 06:00:28 PM
on home page it shows number of categories/images which you have permission to view, and if you are logged in as admin, they should be equal to what you see in ACP.
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: [1.7/1.7.1 (upgrade only)] Categories hits stops at 32767
« Reply #12 on: February 25, 2006, 10:45:33 PM »
hello V@no

sorry for that :)

the proplem sloved when i read you post

Thankyou for help :)

Best Regards,
Logged
Pages: [1]
« previous next »