gallery crushed.

[Omid]

Hello,

we use the invision board and the photopost gallery.
recently the board tables have been emptied due to security problems in ver 2.03 ver olf invision.

i have asked the company that stores my site (nextmill) to restore the tables. and it worked, the board is back online.
http://www.jugend.co.il/invision/index.php

Nevertheless, the gallery refused to get back online.
what it shows is the the top banner over and over thourgh out the page and nothing more.
http://www.jugend.co.il/gallery/index.php

i am using a legal copies of the software.
any help would be appriciated.

[Omid]

i adding a suggestion from nextmill:
"the gallery seems to have its own photo tables in the same database. It might reference some of the invision tables I don't know, I didn't program the product. You might ask the makers of the photo gallery system what might cause it to display like it does. If I am told which table you need restored I can restore it from an older version that might help, but currently it has all the latest tables as you can see the invision board works properly."

[Omid]

Tell us what server operating system you are running: Windows

Tell us what version of PHP and MySQL you are running:
PHP VERSION: 4.3.10 (cgi-fcgi), SQL: (MYSQL) 4.1.11-nt-max
IPB Version v2.0.3 (ID: 20013)


Tell us whether the server in question is a dedicated host or if it is a shared host: i am using nextmill.net services.

Tell us if the server : using nextmill.net services.


Give us a URL that links us straight to your PhotoPost installation. http://www.jugend.co.il/gallery/index.php

[Michael P]

How old were your PhotoPost backups? I'm thinking that the database is not entirely up to date. Specifically the iponline table.

Try, be sure to put any database prefix in place that you may have used:

DROP TABLE iponline;
CREATE TABLE iponline (userid VARCHAR(128) NOT NULL default '',
ipaddr VARCHAR(75) NOT NULL default '',
date INT(11) UNSIGNED,
what VARCHAR(64) NOT NULL default '',
item VARCHAR(16) NOT NULL default '',
PRIMARY KEY (ipaddr)) TYPE=MyISAM;

[Omid]

Originally Posted by Michael P

How old were your PhotoPost backups? I'm thinking that the database is not entirely up to date. Specifically the iponline table.

Try, be sure to put any database prefix in place that you may have used:

DROP TABLE iponline;
CREATE TABLE iponline (userid VARCHAR(128) NOT NULL default '',
ipaddr VARCHAR(75) NOT NULL default '',
date INT(11) UNSIGNED,
what VARCHAR(64) NOT NULL default '',
item VARCHAR(16) NOT NULL default '',
PRIMARY KEY (ipaddr)) TYPE=MyISAM;

thanks!