XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 2 3 (4) 5 6 7 ... 16 »


31
dbman
Re: Need help testing new module Ajaxfilemanager 0.1

  • 2011/3/25 0:48

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


I still cannot upload files. Getting an alert message:

The folder path is not allowed.


No errors in firebug. After I get the message above I cannot close the modal window containing the file upload form.

I can create and delete folders as per the previous version.

Topic | Forum


32
dbman
Re: Need help testing new module Ajaxfilemanager 0.1

  • 2011/3/12 16:14

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


Quote:
This is a bug Any kind of file? Any size? Please tell me more, server info, xoops info?


I've tried a few different file types, even a 32k image file doesn't work.

The server is:
CentOS 5.5
Apache 2.2.17
PHP 5.2.16
- post_max_size = 1073741824
- upload_max_filesize = 1024M
- allow_url_fopen = off
MySQL 5.1.52
XOOPS 2.5


Topic | Forum


33
dbman
Re: Need help testing new module Ajaxfilemanager 0.1

  • 2011/3/12 3:15

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


The module installs without error in XOOPS 2.5. The gmap, ajaxfilemanager and video extension installed without issue. Folder creation works in File Manager. File upload doesn't seem to work.

I've given read,write, execute permissions to the ajaxfilemanager folder. I am trying to upload files with valid upload extensions as defined in Preferences. There are no errors in the debugger for the filemanager and no errors in Firebug.
Topic | Forum


34
dbman
Re: Server crash trouble with all database files Xoops my biggest install, Advice?

  • 2011/3/11 18:37

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


Assuming you are referring to database permissions and not file system permissions.

If you can get the files to load you can set permissions for the required database user using the mysql grant function. For security reasons you would not want to use the root user as the database user for your xoops install. The syntax for the grant function would be:

GRANT SELECT, INSERT, UPDATE, DELETE ON xoops_database.* TO username@'databaseserver' IDENTIFIED BY 'password';


edit:
you'll need to run:
flush privileges;


after you run the grant statement to clear privilege cache.
Topic | Forum


35
dbman
Re: Server crash trouble with all database files Xoops my biggest install, Advice?

  • 2011/3/11 17:43

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


If you have single database file in SQL format you can easily run that directly in your new server or on your local Mac server. Connect to the new database and load or copy paste the file in the SQL editor. If the file was generated as a full SQL backup this will build the tables and insert the records.

If you don't have a SQL file but do have the data files (*.myi, *.myd,etc) use the method mention in the link to restore.
Topic | Forum


36
dbman
Re: Server crash trouble with all database files Xoops my biggest install, Advice?

  • 2011/3/11 15:06

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


Assuming you have the actual data files, you could use the method described in this posting:

http://stackoverflow.com/questions/484750/restoring-mysql-database-from-physical-files

Topic | Forum


37
dbman
Re: Addresses & Google Maps

  • 2011/1/31 19:45

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


I missed the original release of this module. I found and installed after reading here. The tie in with google maps including the map search is great. What will be different in the new addresses module?
Topic | Forum


38
dbman
Re: Moving pics from one site's image manager to another...

  • 2011/1/8 19:45

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


If the databases are on the same host you could use this for image category records:

INSERT INTO database1.table1_imagecategory (imgcat_name, imgcat_maxsize, imgcat_maxwidth, imgcat_maxheight, imgcat_display, imgcat_weight, imgcat_type, imgcat_storetype) SELECT imgcat_id, imgcat_name, imgcat_maxsize, imgcat_maxwidth, imgcat_maxheight, imgcat_display, imgcat_weight, imgcat_type, imgcat_storetype FROM database2.table2_imagecategory;


and this for the image records:
INSERT INTO database1.table1_image (image_id, image_name, image_nicename, image_mimetype, image_created, image_display, image_weight, imgcat_id) SELECT image_id, image_name, image_nicename, image_mimetype, image_created, image_display, image_weight, imgcat_id FROM database2.table2_image;


If both databases are not accessible via sql, you may need to export and load using a csv file or a temporary table in your current database.

Note:
- database1 = your new xoops install
- table1 = your new table prefix
- database2= your old xoops install
- table2 = your old table prefix



Topic | Forum


39
dbman
Re: Can't delete spammers messages (newbb)

  • 2010/11/5 4:30

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


What version of xoops is the site running?
Topic | Forum


40
dbman
Re: Can't delete spammers messages (newbb)

  • 2010/11/4 21:14

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


In phpmyadmin or another client use this SQL statement:
DELETE FROM <prefix>_bb_posts,<prefix>_bb_posts_text USING <prefix>_bb_posts, <prefix>_bb_posts_text WHERE (<prefix>_bb_posts.uid = 308 AND <prefix>_bb_posts.post_id = <prefix>_bb_posts_text.post_id);



Replace <prefix> with your Xoops DB prefix. I see the spammers uid is 308 from the link you posted. Of course you should backup your database prior to executing this statement.


Topic | Forum



TopTop
« 1 2 3 (4) 5 6 7 ... 16 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

228 user(s) are online (154 user(s) are browsing Support Forums)

Members: 0

Guests: 228

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits