While executing query "INSERT INTO cpg1d_pictures (approved, pid, aid, caption, filepath, filename, filesize, pwidth, pheight, hits, mtime, ctime) SELECT 'yes' as approved, p.pid, aid, msg_body AS caption, filepath, filename, filesize, pwidth, pheight, hits, mtime, UNIX_TIMESTAMP(ctime)FROM CPG_pictures AS p LEFT JOIN CPG_comments AS c ON p.caption = c.msg_id " on 0
mySQL error: Table 'coppermine.cpg_pictures' doesn't exist :twisted:
Cmd line :
C:\phpdev\ImageMagick56\convert.execonvert -quality 80 -antialias -geometry 121x100 "c:\phpdev\www\public\k0\junememory\thegallery2\albums\userpics\10001\dogs~0.jpg" "c:\phpdev\www\public\k0\junememory\thegallery2\albums\userpics\10001\thumb_dogs~0.jpg"
The convert program said:
'C:\phpdev\ImageMagick56\convert.execonvert' is not recognized as an internal or external command,
operable program or batch file.
You mustn't have dots in mysql table names!
You probably don't have a file called "convert.execonvert" on your hard drive.
The error messages are pretty self-explanatory to me - if they aren't for you, you're in for some reading; do some research on these items:
- how to set up a server
- how to ask questions properly on any support board in general and on coppermine support board especially
- why beginners shouldn't run their own webserver
- why it's a bad idea to post two different questions in one thread
- why sould I have more intelligent subjects
- what is it that makes supporters so angry that they only critisize my question?
[/list:u]
GauGau
well i guess if this is a message board for only l33t
non php beginners, run by assholes who can't just
politely correct, or even civily ask someone to
act a certain way on the board before flaming
(jesus from an admin no less)
I will make sure all future web design clients use and promote
the much friendlier:
http://www.photopost.com/
and I don't mean to nit pick but perhaps there are some things you should ask yourself...
what happened in your childhood to make you such an angry person.
what the hell is the point of a support board if you're unwilling to support.
why someone who has been running their own server sucuessfully for over 4 years needs to be labled "inexperienced"
I've been using coppermine for quite some time. I just thought I'd try the new version and when I hit a few brickwalls I came here looking for some answers, not even having any attitude. But I certianly didn't expect THIS...
You are rude sir. You're completely unaware of end users or their needs. Furthermore with all your vast knowlage and superior skills in php and sql, you failed to help me. I don't consider that a sucuessful reply.
Well, I think the reason gaugau is angry is because you didn't even bother to take a look at the faq about how you should ask questions, and second is that even for a beginner like me, your problems look quite obvious.
1. coppermine.cpg_pictures: this is going to make mysql look for a field cpg_pictures in a table coppermine(which doesn't exist), when instead you want it to look in a table prefix_pictures . change the table prefixes so they don't contain periods.
2. since it is showing convert.execonvert it seems quite obvious that convert is being called twice. Then it would be logical to remove the extra convert.exe that you set in the config. So the path to imagemagick should be C:\phpdev\ImageMagick56\ instead of C:\phpdev\ImageMagick56\convert.exe
Hope that helps. And if you still want to move to photopost, well go ahead, it's a free world.
Jay
Insidejune,
Let me clue you in:
This is not a commercial product. It is FREE.
Therefore, you have no right to demand tech support.
Also, as it is free, no one really cares if you move to Photopost. Open source is not a genitalia measurment contest.
Your server may have been running itself for the last four years; I doubt you had anything to do with it.
Pick up some books on PHP and MySQL, and remember to ask nicely for things you are not entitled to.
first: calm down, please.
second: the error message
mySQL error: Table 'coppermine.cpg_pictures' doesn't exist
that mysql gives, includes the Database Name - and hats the coppermine part ... so this error message means: in the Database named "coppermine" theres no Table named "cpg_pictures" ...