search

zajako / my-imouto-booru

Automatically exported from code.google.com/p/my-imouto-booru
0 stars 0 forks source link

error when install - "need the SUPER privilege" when creating database. #4

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
sorry but i need you help 

i do everything in text file ''How to install'' .but when i click install 
button , next page is notthing , that is blank page , what is error? how can i 
fix it ?

this is very bad i try shimmie. naranai , imouto.. but not work ...

infor: i intall myimouto into my host <byethost> not  server 

thank you for reading ..

Original issue reported on code.google.com by famy...@gmail.com on 3 Oct 2011 at 5:02

GoogleCodeExporter commented 9 years ago 
You get just a blank page? No errors at all? I don't think I'm able to know 
what's going on without trying to track the error. Try placing this

error_reporting(-1);

on line 2 in the install_commit.php file, you may see an error notice.

Are you sure everything's fine? The database is created? Is it configured 
correctly?

Original comment by asterixvader on 3 Oct 2011 at 11:06

GoogleCodeExporter commented 9 years ago 
well i think i do everything in that text , but i will show you what i do 
<sorry my english ..><>

1
* Extract _myimouto_ folder in your root. >>>> <that line is ok>

2
* Edit files in _config/_.  

>>>>><''this is my config'' and ''dbinfo''>

3
# Base URL with no trailing slash.
define('BASE_URL', '/my folder name '); 

dbinfo
<?php
$server = 'localhost';
$db_user = 'myname user database';
$db_pass = 'PassWord database';
$db_name = 'name database';

 4
* Change your BASE_URL in _javascripts/application.js_ (line 1) and _.htaccess_ 
(line 3).
>>>>application.js
var base_url = "/my forder name/";    >>>well when i set '"/my forder name" not 
change 

htaccess 

RewriteBase /my forder name/   >>>>><like application.js>

5
  * In php.ini enable the fileinfo library and make sure   date.timezone is defined.

>>  php.ini enable and date.timezone in my host i think dont need to change 

6
 * Run the site.    <>>>..... install and get blank page .. no ''error'' txt , nothing happen  
  well this is that all , but i will try find error , please check if that is my fault 

thank you for reading ... wish good thing for you ^^

Original comment by famy...@gmail.com on 4 Oct 2011 at 12:42

GoogleCodeExporter commented 9 years ago 
sorry,in ''3'' that is my ''config'' fle .

Original comment by famy...@gmail.com on 4 Oct 2011 at 12:45

GoogleCodeExporter commented 9 years ago 
Yeah, I forgot to add the step where you create the database... hehe.
Read the HowToInstall wiki.

Original comment by asterixvader on 4 Oct 2011 at 12:53

GoogleCodeExporter commented 9 years ago 
''Hi, I am using it under linux, and there are a few extra steps I had to do. 
I'm writing them here, in case someone need it.

the root folder location varies per distro, most of the time is /var/www or 
/srv/http. php.ini is on /etc/php/php.ini or /etc/php.ini, and at least on my 
system, php_fileinfo functions are activated by default, no need to do anything 
with that. to create the mysql database from command line (without phpmyadmin) 
do as root:

    mysql -u username -ppassword (if it was just installed, probably user is root with no password)
    create database myimouto;
    quit 

my-imouto-booru requires the gd extension. I assume that probably XAMPP already 
have it installed and activated, but I had to manually install the php-gd 
package and activate it on php,ini.

    after install the php-gd, edit /etc/php/php.ini and remove the leading semicolon before extension=gd.so 

also, the apache user has to be the owner of myimouto/ folder, just do: sudo 
chown -R http.http myimouto After all this, you can install it normally. ""

this is the step you said ?

Original comment by famy...@gmail.com on 4 Oct 2011 at 1:02

GoogleCodeExporter commented 9 years ago 
well ,i try  ''error_reporting(-1);''

 still nothing .... i sure that is  my fault but i dont know what is fault ..

Original comment by famy...@gmail.com on 4 Oct 2011 at 1:13

GoogleCodeExporter commented 9 years ago 
my system is linux , Vista panel as you see , i havent  a server , so i dont 
need XAMPP

Original comment by famy...@gmail.com on 4 Oct 2011 at 1:17

GoogleCodeExporter commented 9 years ago 
No, the step I forgot to add in the HOWTOINSTALL file is
"Create a database for the system (name it myimouto by default)."

So if you followed only the instructions found in that file, you skipped the 
creation of the database.

If you created it and you still see a blank page, try debugging the 
install_commit.php file. What I'd do is to add "die('die');" on each line till 
I find the line the script hangs on. Heh. Check if the script successfuly 
includes the 3 files, try adding " || die(mysql_error());" after each 
"mysql_query($sql);"...

If everything's correctly configured, the above tips didn't help, and you still 
see a blank page, let me know.

Original comment by asterixvader on 4 Oct 2011 at 1:44

GoogleCodeExporter commented 9 years ago 
thank you very much ...but 

well i will crazy for that . its no use ... blank page again and i dont skip  
the creation of the database,if i correct . i created database in My SQL 
database 

well today is bad day for me ....i still dont understand , why blank page ?

Original comment by famy...@gmail.com on 4 Oct 2011 at 6:40

GoogleCodeExporter commented 9 years ago 
So even if you put just an echo you'll get a blank page?

Original comment by asterixvader on 4 Oct 2011 at 11:16

GoogleCodeExporter commented 9 years ago 
yes. i think so . im a artist not a coder so i think must be my fault , but i 
cant see what is error in my step ,

Original comment by famy...@gmail.com on 5 Oct 2011 at 5:04

GoogleCodeExporter commented 9 years ago 
Alright...
So you can see the installation page?
The page where see "PHP.ini directives" requirements, and where you place your 
admin account info?

But then when you click on the "Install" button you get a blank page?

I'm attaching an install_commit.php file with a lot of "echo"es. Put this file 
in replacement of your current install_commit.php, and see what happens.

You should At Least see "Hello install_commit.php!". Let me know what's the 
output you get.

If you still get a blank page, that's really strange. in that case, delete 
everything from the install_commit.php file, just leave this:

<?php echo 'Hello world!' ?>

if you still see a blank page, then, well... that's just impossible, something 
would be wrong and it'd be definitely not My.Imouto.

By the way, I'm an artist too... well kinda, I can draw some things. Heh.

Original comment by asterixvader on 5 Oct 2011 at 4:18

Attachments:

GoogleCodeExporter commented 9 years ago 
thank you i will try 
^^ you have a gallery ? ìf you have nyou can find me in devian art or pixiv 

http://famyhp.deviantart.com/
or オオカミ in pixiv , ^^

Original comment by famy...@gmail.com on 6 Oct 2011 at 4:37

GoogleCodeExporter commented 9 years ago 
its worked ... now i know ''error'' name but ...

ít said 

Error: MySQL said: Access denied; you need the SUPER privilege for this 
operation

...

Original comment by famy...@gmail.com on 6 Oct 2011 at 5:14

GoogleCodeExporter commented 9 years ago 
O. Well, there you go... You need an "admin" account for MySQL to create 
triggers, and without them My.Imouto won't work properly.

http://hajimete.deviantart.com/ is my page. I haven't drawn much in a while 
though.

Original comment by asterixvader on 6 Oct 2011 at 5:41

GoogleCodeExporter commented 9 years ago 
well i see ...thank you

your style like carnelian .? do you like her style ? she is one in my favorites 
artist

Original comment by famy...@gmail.com on 6 Oct 2011 at 6:52

GoogleCodeExporter commented 9 years ago 
haha... damn it ... well ,when i talk about admin  account for MySQL with 
byethost support .can you know  answer from them ? you need upgrade your host 
to vps  .. well money for host from my friend ,  need time if i want to pay 
money from myself ....

 ... but now i give up unless i have more money ...

well if you have free time to draw . you can draw with me ... but first  you  
need send me note .. pixiv chat or paint chat ... 

 thank you very much for all . wish best thing for you

Original comment by famy...@gmail.com on 6 Oct 2011 at 7:12

GoogleCodeExporter commented 9 years ago 
Uuh, well, yeah. Well who knows, the triggers could be replaced with PHP in the 
future to avoid these problems.

And yes, style was like Carnelian at first, now it's.. I don't know what it is 
like anymore.

Thanks to you too for reporting, be good.

Original comment by asterixvader on 6 Oct 2011 at 7:19

GoogleCodeExporter commented 9 years ago 
hi everybody! too bad I didn't see this before XD
you don't need admin access to mysql in order to use it in a shared hosting.
Just by using phpmyadmin on your cpanel (most shared host servers give cpanel) 
will allow you to import the database
So, I would recomend you to install myimouto in a local pc and then export the 
database to a sql file, import it on your host server using phpmyadmin and then 
copy using ftp the files from your local installation. sounds difficult but 
actually is quite easy. ;)
I remmember there was a step about editing a file, thats probably the only 
extra step you may need

Original comment by designer...@gmail.com on 11 Nov 2011 at 1:06