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.




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





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.



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 SELECTINSERTUPDATEDELETE 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.



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.



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/48 ... abase-from-physical-files




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?



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_nameimgcat_maxsizeimgcat_maxwidthimgcat_maxheightimgcat_displayimgcat_weightimgcat_typeimgcat_storetypeSELECT imgcat_idimgcat_nameimgcat_maxsizeimgcat_maxwidthimgcat_maxheightimgcat_displayimgcat_weightimgcat_typeimgcat_storetype FROM database2.table2_imagecategory;


and this for the image records:
INSERT INTO database1.table1_image (image_idimage_nameimage_nicenameimage_mimetypeimage_createdimage_displayimage_weightimgcat_idSELECT image_idimage_nameimage_nicenameimage_mimetypeimage_createdimage_displayimage_weightimgcat_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






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?



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.






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



Login

Username:
Password:

Lost Password? Register now!

Who's Online

65 user(s) are online (34 user(s) are browsing Support Forums)


Members: 0


Guests: 65


more...

Donat-O-Meter

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

Latest GitHub Commits