[RevCMS] #1136 / Values.. [URGENT]

[funkystrainz]

Hey all,

When I try to run an insert query in my users table, and try to add values, I get either "15 errors found during analysis" or one that says "Column count doesn't match value at row 1".

Screenshots (from another thread):

You must be registered for see links

You must be registered for see links

I'd like to be able to move forward. The only thing I can find in tutorials is for a seckey fix and the CMS already comes with a seckey.

Thanks

 

[Joe]

What exactly are you trying to add? Also, next time, post the thread

You must be registered for see links

.

 

[Core]

You can't just copy a PHP query and expect phpmyadmin to interpret it lmao. Rip.

 

[funkystrainz]

What exactly are you trying to add? Also, next time, post the thread

You must be registered for see links

.

I've been trying a few different things to be able to get my database to update with submitted entries. This is just the only time there was something that communicated with me from the database. I thought if I inserted the matching values from one of my CMS pages, into my users table using a query (written in PHP, from my CMS), that it would somehow allow for the submitted data from placeholders to translate into updated rows in my database.

I'll keep trying other things. Probably like trying to get the placeholders to submit their information from the reg page. Like with this script:

final public function validName($username)     
    {
        if(strlen($username) <= 25 && ctype_alnum($username))         
         {             
             return true;         
         }                 
        
         return false;     
    }         
        
    final public function validEmail($email)     
    {         
        return preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email);     
    }         
    
    final public function validSecKey($seckey)
    {
        if(is_numeric($seckey) && strlen($seckey) == 4)
        {
            return true;
        }
        
        return false;
    }

 

[Menkz]

what "page" are you trying to insert values with?

 

[Xuxu]

dude get a windows vps or computer jesus!

 

[funkystrainz]

what "page" are you trying to insert values with?

The snippet I posted was copied from my class.users. Everything that I've tried to insert as values has also been from a different part of this page.

 

[Menkz]

I know what class.users looks like, but what page, me, index, staff?

 

[funkystrainz]

I know what class.users looks like, but what page, me, index, staff?

Oh, I've linked my reg to my index, so I can click from one to the other. I need for the forms in both pages, to submit the info from placeholders, and direct me to the me page. All of this query stuff is so the rest of values update in my db with the success of the form.

 

[Menkz]

login

<form  action="index" method="post">
            >
              <input type="text" name="log_username" id="username" placeholder="Username">

<input type="password" name="log_password" id="password" placeholder="Password" >
            </div>
            <button type="submit" name="login">Sign in</button>
          </form>

Register

<form action="register" method="post">
              
                <label for="Username">Username</label>
                <input type="text" name="reg_username" id="username" value="<?php echo $template->form->reg_username; ?>" placeholder="Username">
              </div>
              
                <label for="email">Email</label>
                <input type="email" name="reg_email" id="email" value="<?php echo $template->form->reg_email; ?>">
              </div>
              
                <label for="pass">Password</label>
                <input type="password"  name="reg_password" id="password" placeholder="Password">
              
              
                <label for="confpass">Confirm Password</label>
                <input type="password"name="reg_rep_password" id="retypenpassword" placeholder="Confirm Password">
              

              <button type="submit" name="register">Submit</button>
            </form>

edit these how you see fit

 

[funkystrainz]

login

<form  action="index" method="post">
            >
              <input type="text" name="log_username" id="username" placeholder="Username">

<input type="password" name="log_password" id="password" placeholder="Password" >
            </div>
            <button type="submit" name="login">Sign in</button>
          </form>

Register

<form action="register" method="post">
            
                <label for="Username">Username</label>
                <input type="text" name="reg_username" id="username" value="<?php echo $template->form->reg_username; ?>" placeholder="Username">
              </div>
            
                <label for="email">Email</label>
                <input type="email" name="reg_email" id="email" value="<?php echo $template->form->reg_email; ?>">
              </div>
            
                <label for="pass">Password</label>
                <input type="password"  name="reg_password" id="password" placeholder="Password">
            
            
                <label for="confpass">Confirm Password</label>
                <input type="password"name="reg_rep_password" id="retypenpassword" placeholder="Confirm Password">
            

              <button type="submit" name="register">Submit</button>
            </form>

edit these how you see fit

That just leads me back to here:

You must be registered for see links

Submitting filled in fields that return as empty when the page refreshes. There is no forward action or communication between the db and the me page. But, the two pages on their own shouldn't be able to do anything
 
If my forms are written for bootstrap, could that be the problem?

 

[Menkz]

No, as my theme is purely bootstrap.

What CMS do you use?