Jump to content


  • Posts

  • Joined

  • Last visited

Posts posted by stephennoble

  1. Hi Killersites community,

    Recently i've made a wordpress site.... looks perfect, but when i FTP my site to a remote server none of the images will display.....

    I followed along exactly with the tutorial series 'wordpress and dreamweaver', but instead of displaying it displays text instead....

    All the images transfered over to the server but they won't evan display their thumbnails


    Also when you transfer a wordpress site using FTP with dreamweaver when it prompts you to include dependent files should you say yes or no?



  2. Hi Killersites Crew,

    Cheers for the comments...... I actually ended up finding a clip on you-tube that helps you change

    your phpMyAdmin Password....... The problem is that you need to change it not only in PHPMyAdmin UserInterface, but to make it work


    You also need to also change the password in the config.inc.php file ...... to make it work.....


    Directory C:\wamp\apps\phpmyadmin3.5.1


    ANYWAY here's the link:



    ENJOY :)

  3. Nobes,

    Thank you so much!

    Your problem is my solution!

    I could not get access to the database, and thus could not follow

    along in the CRUD with PHP and MYSQLI course.


    I turned off my firewall and went through many pages of Google

    search results, but still kept getting the access denied message.


    In your post, you use $pass = '';

    I updated by connect-db.php file from using $pass = 'root'; to using $pass = ''; and it works!!!


    I'm so excited.


    Question for you--if $pass = ''; works for you, then why add a password?


    Anyway, I hope someone can help you, but if all else fails and you still want

    a password, you can simply reinstall WAMP. (Save the www subdirectory somewhere else first

    so you don't lose your files.)


    That's alright mate......it's awesome that i could help you...

    "I updated by connect-db.php file from using $pass = 'root'; to using $pass = ''; and it works!!!"


    Yeah i was having the same problem because i was following along with the tutorials the same way as you

    and using ROOT as the password wasn't working so i just tryed using no password.....


    HOPEFULLY BEN or Stefan.....from Killersites.....

    know the answer to this problem......


    Your Server should use a password because it's more secure... and better practice......


    BUT CHANGING IT inside PhpMyadmin is a nightmare when using WAMP.......

    And this shouldn't be the Case when you consider how much code goes into making WAMP you'd think

    they could get this right......

  4. Hi Killersite Community,

    I was wondering if someone could help,,, i've searched online for hours tried every possible solution

    but still with no luck at changing the root USER password of my PHP myAdmin MySql from:


    $server = 'localhost';

    $user = 'root';

    $pass = ''; /////// If i use root as password it dosen't work...... if i use $pass = ''; it works

    $db = 'fp_cms';



    I tryed changing the root password using the phpmyadmin user interface but keep getting errors.......


    USER PASSWORD with out getting ERRORS



    I'm sure i'm not the first person to to encounter this problem.....



    BELOW IS THE instructions i used to change MY ROOT password in WAMP..... didn't work



    C. Resetting the Root Password: Windows Systems


    On Windows, use the following procedure to reset the password for all MySQL root accounts:


    1. Log on to your system as Administrator.


    2. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

    From the Start menu, select Control Panel, then Administrative Tools, then Services. Find the MySQL service in the list and stop it.


    If your server is not running as a service, you may need to use the Task Manager to force it to stop.


    3. Create a text file containing the following statements. Replace the password with the password that you want to use.


    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; /// change 'MyNewPass' to the new password you want



    Write the UPDATE and FLUSH statements each on a single line. The UPDATE statement resets the password for all root accounts,

    and the FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change.


    4. Save the file. For this example, the file will be named C:\mysql-init.txt.


    5. Open a console window to get to the command prompt: From the Start menu, select Run, then enter cmd as the command to be run.


    Start the MySQL server with the special --init-file option (notice that the backslash in the option value is doubled):


    6. C:\> C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt


    7. FOR MY MACHINE USING WAMP Type this line






    c:\wamp\bin\mysql\mysql5.5.24\bin\mysqld.exe wampmysqld --init-file=C:\\mysql-init.txt

  5. The issue is due to this section: "md5($pass . $this->salt)". Take a look at the OOP section here for a fix:





    CHEERS BEN..... quite a easy fix....... WAMP really throws a tantrum when you have errors on strict....


    Do you think this new error occurs because i'm using a newer version, than when you made the tutorials ????

  6. Hey Killer Sites Community,


    Pretty new to this level of programming wondering if someone knows how to fix this problem?


    I've been following BEN's tutorial series (Building a CMS System video 23) line for line but getting errors that Ben is not getting.

    I'm currently running the latest version of WAMP and PHP, My code still runs but getting this error as well....

    find error screen shot in attachments




    post-44369-040675800 1345086173_thumb.jpg


    Strict standards: Only variables should be passed by reference in C:\wamp\www\CMS\app\core\models\m_auth.php on line 34


    function validateLogin($user, $pass)
    	global $FP;
    	// Calling the main Database from the main $FP flight path object
    	if ($stmt = $FP->Database->prepare("SELECT * FROM users WHERE username = ? AND password = ?"))
    		$stmt->bind_param("ss", $user, md5($pass . $this->salt));     // LINE 34
    		// check for num rows
    		if ($stmt->num_rows > 0)
    			// success
    			return TRUE;
    			// failure
    			return FALSE;
    		die("ERROR: Could not prepare MySQLi statement.");

  • Create New...