Try the myAlbum module for XOOPS from here :

http://www.peak.ne.jp/xoops/modules/mydownloads/singlefile.php?cid=1&lid=19

Its superb and I am using for the entire submission structure of reports for my site. I had no problems with it, except you need thumbnails graphics for it to use for its catergories. There does not seem to be a way of telling it not to request a thumbnail.

Try it anyway. You got nothing to lose.

Its a mystery indeed. Well thanks for your help anyway. If anyone happens to know the answer please can you e-mail me at tedsmith28@yahoo.co.uk. Thanks

<?php phpinfo() ?>
displays the php configuration page as it should

The database file says that it Connected Successfully, but follows with a PHP Notice :

"Use of undefined constant host - Assumed 'localhost', Use of undefined constant 'root' - assumed 'root', etc.

In other words, I think both are OK?

I don't know the factual answer for this, but I doubt 123 an hour will cause XOOPS problems. Besides, I think its the database backend which is more of the issue - how many can that handle? If its MySQL it should be thousands (I think). If its Access then not so good! Perhaps its more related to the amount of bandwidth your ISP allows you to have. For example, if you are having 123 visitors, and each are browsing a lot and downloading stuff, then your bandwidth requirement will have to be high. I'd check with your ISP and check what your prescribed service allows you.

Hope that helps.

Not sure if I've got the wrong end of the stick, but I just updated the cache lifetime in the Administrators Panel\modules\whoisonline module to 30 seconds and that seems to be working for us without changing group permissions, but we are on an internal Intranet which may affect it.

Hi

Apologies if this is not in the appropriate category and it relates mostly to MySQL and phpMyAdmin together....

Before I start, let me say that I have already installed XOOPS successfully, and previously installed and ran phpMyAdmin.

I recently recovered from a rather serious XOOPS system failure, and suffice to say I had to flush the root privilages of the MySQL server etc to get it back on line. It now works again.

Anyway, when I went to my phpMyAdmin folder (which worked fine before the crash) I got blank screens or 'No Input File Specified' if I addressed a specific file like install.php. The latter I'd had before and it related to my IIS configuration and permissions, but seeing as XOOPS works fine now I fail to see how it could be that.

I read the phpMyAdmin docs as well as various other forums and they suggested ensuring that permissions were set for IUSER_[MACHINE] which they were. It went on ....

Change OBGZipdirective to FALSE in the phpMyAdmin configuartion file. Did that.

Changed the reference to 'localhost' to our specific domain and the phpMyAdmin path (http://fct.local/phpmyadmin/. Did that.

Changed the cgi.force_pathname value to 1 instead 0. Did that.

Tried typing in the browser :

http://fct.local/phpmyadmin/
http://fct.local/phpmyadmin
http://fct.local/phpmyadmin/install
http://fct.local/phpmyadmin/install.php
http://fct.local/phpmyadmin/index
http://fct.local/phpmyadmin/index.php


All of this, and it still doesn't work! Even though before I just copied it to the folder and navigated to it, and it worked brilliantly. I just don't get it.

There is some light however. When I downloaded and installed the XOOPS Modular version that works a treat, but only for the XOOPS database. I want phpMyAdmin to maintain the whole of MySQL on our server. So why does the XOOPS module work, but the main one doesn't? Bizarre.

Versions :
IIS6
Windows 2003 Server
php 4.3.6
phpMyAdmin 2.5.7 (Global Version - unsure what XOOPS module is but got to it from www.iis-resources.com in the dowloads section)
MySQL 4.0.20
Xoops 2.0.6

Any ideas what may be causing this? I would like global database control using phpMyAdmin

I agree. I think a core module that allows a webmaster to create forms of many kinds to suit the specific needs is superb. I hope one day someone can do it (please let me know if they do!!).

In the meantime I will use the MyAlbum module and customise it a little as necessary, as suggested in the post b4 last. Hopefully that will be OK.

Really though I wanted a professional sleak area for registering a lost or found dog, and another are for searching the lost and found dog cateories.

Anyway, who knows. Perhaps now we should close the thread? We can speculate for hours!

Sorted it.

Closed down MySQL service, and then opened a DOS shelled instance of mysqld-nt --skip-grant-tables from c:\mysql\bin. Then I flushed the password for root by typing

mysqladmin -u root flush-privileges password "entered a new password"

and pressed enter. Then I shutdown the service again by typing mysqladmin -u root -p shutdown. It asked me for the password and shutdown. I then re-started it and hey presto!

Now got to work out why it did it in the first place!

If anyone else has this problem got tohttp://dev.mysql.cm/dc/mysql/en and look up 'resetting root permissions'.

Hi everyone

I'm sure this should be a quick one, hopefully. I have readhttps://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=8208&forum=1 and note some people are having similar problems as me, but not the same as me, and the areas that are similar I have already tried before. Let me explain....

I successfully configured and installed IIS6, php, MySQL, and W2&3 Server to run our internal Intranet (NO External connection to Internet). At first, when installing Xoops, I got database connection problems too (which is when I cam here originally). When I uninstalled MySQL, and re-installed it, and used username of root and a password, it worked great. I set up Xopps, and started to play. Everything worked a treat.

Then, today, another one of my guys logged off the server. When I logged back on (not that I should have even had to do that because I set MySQL to run as a Windows service using mysql-nt.exe --install) no Xoops! It says it "cannot connect to the database. Unable to connect to database in file blah/blah/blah/databasefacotry.php."

If I try to directly access phpMyAdmin (which also worked before) by going tohttp://fct.local/phpMyAdmin I get

#2003 Can't connect to MySQL Server on 'localhost' (10061).

If I shell to c:\mysql\bin and type mysql, and ask it to 'show databases' all it shows is the test database, even though the XOOPS database is in the c:\mysql\data folder, along with another one called 'mysql'.

If I type 'mysql -u root -p' I get the following error :

ERROR 1045 : Access denied for user root@locahost <using Password = YES'>.

I checked mainfile.php and the user name and password are exactly as I gave MySQL when I re-installed it, so that hasn't changed.

If I run winmysqladmin.exe I get green lights, and the password in the my.ini file matches the mainfile.php. But even in that, only the test database show up.

It seems to me then, that for some reason, MySQL has locked out root and thinks that the password is no longer what it was originally. How on earth do I get round that!!??

Specifications are :

IIS6,
MySQL 4.0.20
PHP 4.3.6
phpMyAdmin 2.5.7
IIS6
W2&3 Server
Xoops 2.0.6

Please can someone help me?

I'm now having this same problem except I can't just re-install MySQL and XOOPS because I was half way through setting everything up.

If I go to the MySQL shell and type 'show databases;' all I get is Test too. However, in the MySQL\Data folder, the database I made is there with all the XOOPS data in it.

If I try to access the site I get the 'Error - cannot connect to database specified in d:\....\...\databasefacotry.php. I know that ll the details (passwrod etc) must be correct because it enabled me to set up XOOPS and get all that way with setting it up.

This has happended incidentally after someone logged the server off. I had not anticipated that other than typing 'mysql-nt --install' after setting up MySQL to ensure it was started after a reboot!

Any ideas.