PEAK XOOPS - db error: insert category in englishin japanese

db error: insert category

  • You cannot open a new topic into this forum
  • Guests cannot post into this forum
Previous post - Next post | Parent - Children.1 | Posted on 2006/4/13 2:28
Callo  二等兵   Posts: 7
Hi new to xoops and myalbum. Trying to set up for the first time and whenever I go to add a new category I receive the error "db error: insert category" I'm making sure to fill in all the fields (although I do not understand what the banner url is for) but no luck.

I'm sure I've skipped or missed something but I can't find any FAQs or a help doc. Can someone ppoint me in the right direction. and if there is a user doc somewhere please let me know so I can give it a read through!
Votes:26 Average:6.54
Previous post - Next post | Parent - Children.1 | Posted on 2006/4/13 4:56
GIJOE  先任軍曹   Posts: 4110
Which version of myAlbum-P?

Anyway, try "update module" again.
Votes:9 Average:8.89
Previous post - Next post | Parent - Children.1 | Posted on 2006/4/13 23:28
Callo  二等兵   Posts: 7
k ran update, it said successful, and I'm still getting the same error.

I'm using myAlbum-P version 2.84

Thanks for your help!
Votes:18 Average:9.44
Previous post - Next post | Parent - Children.1 | Posted on 2006/4/14 5:41
GIJOE  先任軍曹   Posts: 4110
Try the latest version.
Or, check the table (myalbum_cat) is broken or not.
Votes:23 Average:6.09
Previous post - Next post | Parent - Children.1 | Posted on 2006/5/3 0:59
Callo  二等兵   Posts: 7
Okee dokee. I finally got back around to messing with this... I upgraded to 2.9 and in the administration everything seems alright but now I can't upload pictures.

My photos and thumbs folders are both chmod 777 and under:

/uploads/photos
/uploads/thumbs

I ran the album checker and received this message as the only problem:

PHP directive 'upload_tmp_dir': Error: upload_tmp_dir (/upload_tmp) is not writable nor readable .

Can you tell me what I have goofed now?

Thanks for all your help!
Votes:24 Average:6.25
Previous post - Next post | Parent - Children.1 | Posted on 2006/5/3 10:15
GIJOE  先任軍曹   Posts: 4110
chmod 777 /upload_tmp

There are a lots of informations in the net about the "permission"
Votes:9 Average:7.78

question Re: db error: insert category

msg# 1.1.1.1.1.1.1
Previous post - Next post | Parent - Children.1 | Posted on 2006/5/3 23:18
Callo  二等兵   Posts: 7
okay well I assumed that but where should this upload_tmp directory be? I don't see one in my upload folder or in the module itself. If I need to create it that's no problem but I need to know where the module is looking for this dependancy.

Thanks
Votes:9 Average:8.89

question Re: db error: insert category

msg# 1.1.1.1.1.1.1.1
Previous post - Next post | Parent - Children.1 | Posted on 2006/5/4 6:04
GIJOE  先任軍曹   Posts: 4110
Is it your owned server?
Or shared hosting?

If former, edit php.ini directly and restart httpd.
check the line of...
upload_tmp_dir =

If latter, you'd better ask it to the administrator
Votes:15 Average:5.33

question Re: db error: insert category

msg# 1.1.1.1.1.1.1.1.1
Previous post - Next post | Parent - Children.1 | Posted on 2006/5/5 3:09
Callo  二等兵   Posts: 7
Alright I'll check with my host and let you know of my progress. Thanks.
Votes:21 Average:6.67

question Re: db error: insert category

msg# 1.1.1.1.1.1.1.1.1.1
Previous post - Next post | Parent - No child | Posted on 2006/5/11 0:40
Callo  二等兵   Posts: 7
Okay! looks like I was able to fix my issue. I had to create an .htaccess file that used the directive:

<IfModule mod_php4.c>
php_value session.save_path /upload_tmp
</IfModule>

Then I created the directory upload_tmp where I specified. Worked like a champ!
Votes:24 Average:6.25

  Advanced search


Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!