i was trying to install, all was fine until i tried the identification page
** Broken link**
or the admin panel
** Broken link**
any ideas what is going wrong?
thanks in advance
Scott
can you add in file include/config.php line 33 :
echo $query;
before
$row = mysql_fetch_array( mysql_query( $query ) );
Offline
added but it still gives quite a few errors
can you check whether you have a table "phpwebgallery_config" in your database or not ?
Offline
here is the pb, I suppose ;)
So you have to create tables manually !
Before that, can you delete all files of PhpWebGallery, and totally reinstall it, please.
Offline
yeah it makes for a lot of errors 8)
is there a dump.sql for manually importing via phpmyadmin?
Offline
is there a dump.sql for manually importing via phpmyadmin?
no, but I am preparing one for you. 5 minutes
Offline
CREATE TABLE `phpwebgallery_categories` ( `date_dernier` date NOT NULL default '0000-00-00', `nb_images` smallint(5) unsigned NOT NULL default '0', `name` varchar(255) default NULL, `id_uppercat` tinyint(3) unsigned default NULL, `id` tinyint(3) unsigned NOT NULL auto_increment, `comment` text, `dir` varchar(255) NOT NULL default '', `rank` tinyint(3) unsigned default NULL, `status` enum('visible','invisible') NOT NULL default 'visible', PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_config` # CREATE TABLE `phpwebgallery_config` ( `periode_courte` smallint(5) unsigned NOT NULL default '7', `periode_longue` smallint(5) unsigned NOT NULL default '14', `prefixe_thumbnail` varchar(10) NOT NULL default 'TN-', `webmaster` varchar(255) NOT NULL default '', `mail_webmaster` varchar(255) NOT NULL default '', `acces` enum('libre','restreint') NOT NULL default 'libre', `session_id_size` tinyint(3) unsigned NOT NULL default '4', `session_keyword` varchar(255) NOT NULL default '', `session_time` tinyint(3) unsigned NOT NULL default '30', `max_user_listbox` tinyint(3) unsigned NOT NULL default '10', `expand` enum('true','false') NOT NULL default 'false' ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_history` # CREATE TABLE `phpwebgallery_history` ( `date` int(11) NOT NULL default '0', `login` varchar(15) default NULL, `IP` varchar(50) NOT NULL default '', `categorie` varchar(150) default NULL, `page` varchar(50) default NULL, `titre` varchar(150) default NULL, `commentaire` varchar(200) default NULL ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_images` # CREATE TABLE `phpwebgallery_images` ( `id` smallint(5) unsigned NOT NULL auto_increment, `file` varchar(255) NOT NULL default '', `cat_id` tinyint(3) unsigned NOT NULL default '0', `date_available` date NOT NULL default '0000-00-00', `date_creation` date default NULL, `tn_ext` char(3) NOT NULL default 'jpg', `name` varchar(255) default NULL, `comment` varchar(255) default NULL, `author` varchar(255) default NULL, `hit` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `cat_id` (`cat_id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_restrictions` # CREATE TABLE `phpwebgallery_restrictions` ( `user_id` tinyint(3) NOT NULL default '0', `cat_id` tinyint(3) NOT NULL default '0', PRIMARY KEY (`user_id`,`cat_id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_sessions` # CREATE TABLE `phpwebgallery_sessions` ( `id` varchar(255) binary NOT NULL default '', `user_id` smallint(5) unsigned NOT NULL default '0', `expiration` int(10) unsigned NOT NULL default '0', `ip` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `phpwebgallery_users` # CREATE TABLE `phpwebgallery_users` ( `id` smallint(5) unsigned NOT NULL auto_increment, `pseudo` varchar(20) binary NOT NULL default '', `password` varchar(255) NOT NULL default '', `nombre_image_ligne` tinyint(1) unsigned NOT NULL default '5', `nombre_ligne_page` tinyint(3) unsigned NOT NULL default '3', `theme` varchar(255) NOT NULL default 'eexell/coldblue', `sexe` enum('M','F') NOT NULL default 'M', `status` enum('admin','membre','visiteur') NOT NULL default 'visiteur', `language` varchar(50) NOT NULL default 'english', `maxwidth` smallint(6) default NULL, `maxheight` smallint(6) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `pseudo` (`pseudo`) ) TYPE=MyISAM; INSERT INTO phpwebgallery_config VALUES (7, 14, 'TN-', 'webmaster', 'webmaster@domain.com', 'libre', 6, '', 30, 10, 'true'); INSERT INTO phpwebgallery_users VALUES (1, 'webmaster', 'd41d8cd98f00b204e9800998ecf8427e', 7, 4, 'eexell/coldblue', 'M', 'admin', 'english', NULL, NULL); INSERT INTO phpwebgallery_users VALUES (2, 'visiteur', 'd41d8cd98f00b204e9800998ecf8427e', 4, 2, 'eexell/coldblue', 'M', 'visiteur', 'english', NULL, NULL);
Warning : log as webmaster, there is no password. The first thing to do is to go to the admin pannel and to change your password
Offline
thanks for all your help so far.
was a bit of a fiddle but i got the admin part to work
the rest seems to be having a bit of a problem though.
i think the script is not connecting to the db at all
the password updates i made now dont work
when i go back to galleries from admin i get this
** Broken link**
any ideas?
Offline
as far as I can see, it works good, but you have no pictures in your directories. Have you ?
Offline
hmm seems i need to keep refreshing to get any changes picked up on a reload.
but apart from that it seems to be working now.
thanks a lot for all the help
i will keep you posted as to anything that crops up.
:D
Offline