When you connect the battery the red cable sparks upon touching the terminal.
That should not happen *if* the igntion switch is 'off'.
No current should flow while your scooter is idle.
Sparks might be seen if the red cable is connected with the ignition "on" as the tail light is powered by the battery
When cables are connected the headlight is on very dimly. Why would it does this?
The headlight should only come on when the engine is running, as it is powered via AC generated by the stator. Voltage to light the head lamp is present only when the engine spins the flywheel mounted magnets past the stator.
Try unplugging the Rectifier/Regulator, when failed, the regulator has caused discharged batteries, blown fuses, melted wires and even a plume of smoke for members. If unplugging eliminates the headlight on condition, your regulator is bad.
Also when I pushed the starter button nothing happened. any help or advice is greatly appreciated.
You may have more than one issue. If the regulator is bad it can discharge your battery past the point of starting, and will drain the battery with the ignition switch off.
With a multimeter/DMM in hand, you can make progress on this issue. Given the above issues, I'd place the meter across the battery, and monitor DC voltage. If its under 10.5v or so when you press the start button, the starter relay may not pull in.
Recharge your battery, unplug the regulator, then troubleshoot your starter circuit.
- Starter still not working?
If you can hear the relay click, it's pulling in, next step is to check for bad starter relay contacts, bad connections between the starter relay -> starter or starter ground.
The starter may be failed, you can pull the starter and connect across a battery to check.
Lastly, regarding simple things that go wrong, make sure you have the brakes on when activating the start button. It is a safety interlock Honda designed in. The brake light must be 'on', to supply power to the starter relay coil.